-
Module 1: Overview of SSIS
13 Lessons-
StartWhat is SSIS?
-
StartTypical role for SSIS
-
StartCommon sources of data
-
StartCommon integration challenges
-
StartTooling for building SSIS packages
-
StartSSIS project system
-
StartWhat are packages?
-
StartSSIS toolbox
-
StartSQL Server Management Studio
-
StartLab 1a: Installing Integration Services Projects
-
StartLab 1b: Overview of SSIS
-
StartLab 1b: Walkthrough
-
StartQuiz 1: Overview of SSIS
-
-
Module 2: Working with control flow
16 Lessons-
StartWhat is control flow?
-
StartPrecedence constraints
-
StartTask disable and execute
-
StartNaming annotating and grouping
-
StartVisual layout controls
-
StartCommonly used tasks
-
StartOther built-in tasks
-
StartVariables
-
StartExpressions
-
StartParameters
-
StartScript task
-
StartContainers
-
StartTask breakpoints
-
StartLab 2: Working with control flow
-
StartLab 2: Walkthrough
-
StartQuiz 2: Working with control flow
-
-
Module 3: Working with data flow
15 Lessons-
StartWhat is the data flow?
-
StartTypical data flow
-
StartBuilt-in data sources
-
StartSetting component properties
-
StartNormal flow vs error flow
-
StartBuilt-in data destinations
-
StartBit bucket destination
-
StartBuilt-in transformations
-
StartMulti-output transformations
-
StartScript component
-
StartData type conversions
-
StartData paths
-
StartLab 3: Working with data flow
-
StartLab 3: Walkthrough
-
StartQuiz 3: Working with data flow
-
-
Module 4: Configuration and deployment
13 Lessons-
StartEarlier version configuration
-
StartProject configuration
-
StartProperty expressions
-
StartDefault parameter values
-
StartSSIS catalog
-
StartProject deployment
-
StartTarget versions
-
StartEnvironments
-
StartSSIS Catalog programmability
-
StartDeploying to Azure Data Factory
-
StartLab 4: Configuration and deployment
-
StartLab 4: Walkthrough
-
StartQuiz 4: Configuration and deployment
-
-
Module 6: Advanced tasks and transforms
9 Lessons -
Module 7: Reliability and performance
9 Lessons
