Introduction to the Data Flow Task
o Connection Manager and Data Flow Task basics: source and destination adapters
o Exercise: Straight to the Data Flow
Lesson 3: Data Flow Task 201 - Intermediate Data Flow Concepts
o Building re-executable data loaders
o Exercise: Create a Real Data Flow, Parts 1 and 2
Lesson 4: Data Flow Task 202 - Advanced Data Flow Concepts
o Building and tuning robust incremental loader
o Exercise: Create a Real Data Flow, Parts 3 and 4 #
Lesson 5: Data Flow Task 301- Data Cleansing Basics.
o Building an incremental loader for real-world data
o Exercise: Data Cleansing, Part 1
Lesson 6: The Control Flow - Containers, Precedence, and Workflow
o Transactions, restart-ability, and blocking
o Exercise: Sequence Containers
Lesson 7: Loop Containers - Using For Loop and For Each Loop Containers.
o Exercise: Loading Multiple Source Files
Lesson 8: Data Flow Task 302 - Intermediate Data Cleansing. Managing real-world changes to data sources.
o Exercise: Data Cleansing, Part 2
Lesson 9: Data Flow Task 303 - Advanced Data Cleansing
o Loading uneven flat file sources
o Exercise: Design Pattern: Loading Variable-Length File Sources.
Lesson 10: Event Handlers, Logging, and Configurations - Survey of SSIS Event Handlers Focusing on OnError and OnInformation Events
o Using SSIS’s built-in logging facility to capture package execution details and statistics, and built-in package configurations to externalize variable values
o Exercise: Trapping and Logging Errors, Part 1
Lesson 11: Security, Deployment, and Execution - SSIS Package Deployment Options and Security Implications
o Execution options
o Exercise: Package Execution Options
Lesson 12: ETL Design Patterns - Leveraging Less-Documented Features of SSIS with the Parent-Child Design Pattern to Achieve “hands-free” Custom Logging and Creative Custom Configuration.
o ETL Instrumentationo Exercise: Trapping and Logging Errors, Part 2
Lesson 13: Enterprise Execution Patterns - Leveraging the Parent-Child design pattern to build a metadata-driven SSIS execution engine.
Lesson 14: SSIS Performance Demonstrations of common SSIS performance-killers and “SSIS deadlocks”. A methodology for troubleshooting SSIS performance.
You will need to bring your laptop and you will need a version of SQL Server 2005 or newer - preferably 2008 or 2008 R2. SSIS will need to be installed and functioning. You can obtain a 180-day Trial Edition of SQL Server 2008 R2 here.