Course details

SSIS Variables

SSIS Variables


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
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.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
0.6

Lesson Objectives

SSIS Variables

  • 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
  • Course Number:
    md_idwm_a09_it_enus

    Expertise Level
    Intermediate