Friday, November 14, 2014

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 Taskdynamic SQL query.
¨Derived Column” validate or assign value to a column.
¨Conditional Splitto 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.

No comments:

Post a Comment