Varaiables

¨Variables – Data Types, scope, Namespace and naming conventions.

¨Variables – Debugging using Breakpoints.

¨Variables – User & System Variables using ‘Package Configurations’.

¨Variables – Using .NET in a Script Task. (Control Flow)

¨Variables – Using .NET in a Script Component. (Data Flow)

¨Expressions and Dynamic SSIS.

¨Expressions - Operators, Functions, Literals and Casting.

¨Using the Expressions builder and the Expression Tester Application.

¨Common String, Numeric, NULL, Conditional and Date & Time examples.

Variables:A place holder for your values, used to store and pass values between tasks and containers internally or between packages (child and parent packages.

Expressions:An expression is a combination of multiple operators and functions and could reference multiple columns or variables to yield a single data value.

Variables – Scope , NameSpace:
A way to organize your package and limit your variables to a certain task using Scopes or NameSpaces.

As variables’ names are unique, you can have the same name across multiple ‘Scopes’ or ‘Name spaces’

Variables – Package Configurations:
Read & write to system and User variables using ‘Package Configurations’

Variables – Reading / Writing Using .Net:

Script Task (Control Flow)

Script Component (Data Flow Task)

Expressions:

¤used to assign values to variables, update or populate properties at run time, define constraints in precedence constraints, and provide the expressions used by the For Loop container.

¤The language is somehow similar to the curly braces languages (C++,C# or Java ).

¤Almost any task in SSIS, if not all, can use expressions to make its properties dynamic.

¨“Execute SQL Task” dynamic SQL query.

¨“Derived Column” validate or assign value to a column.

¨“Conditional Split” to split a column based on a specific condition.

¨“Precedence Constraints“ direct the flow to a different route based on a custom condition within the Control Flow.