SQL Server 2014 allows for the use of parameters, variables, and expressions to create dynamic packages. This course covers SSIS variable concepts, such as system variables, scope, parameterization of properties, and data types.
- start the course
- implement user variables
- define a variable scope
- describe data types
- implement parameterization of properties using variables
- use variables in precedence constraints
- refer to SSIS system variables