MSBI # 12 – SSIS # 5–Familiar with SSIS Variables from 0 to Expert (Part–III– Overview)

Continuing from my last post on variable basics ,you can click here to view MSBI # 10 – SSIS # 3–Familiar with SSIS Variables from 0 to Expert (Part–I-Introduction) « (B)usiness (I)ntelligence Mentalist

And then on for System Variable MSBI # 11 – SSIS # 4–Familiar with SSIS Variables from 0 to Expert (Part–II – System Variable) « (B)usiness (I)ntelligence Mentalist

Where SSIS Variables are used

Variables Usage Scenarios
Property Expressions
Data Flow Expressions
Precedence Constraint Expressions
Parameters and Return Codes
For Loop Expressions
Parent Package Variable Configurations
Script Task and Script Component

For more Details on above usage Click Here

How to: Set the Properties of a Variable

The Variables window.
The Properties window. The Properties window lists properties for configuring variables that are not available in the Variables window: Description, EvaluateAsExpression, Expression, ReadOnly, and ValueType.

For more Details on above usage Click Here

Converting SSIS Data Types to .Net Data Types

If you use Scripting tasks, the CLR or build components for SSIS, you will need to convert values from their SSIS types into .Net types. Here’s a quick list of the SSIS data types and their .Net companion.