The target audience for this training is database
professionals, application developers, and business intelligence practitioners
interested in acquiring or expanding their existing SSIS skill set. No
experience with SQL Server or SQL Server Integration Services is required before
attending this training. It is helpful (but not required) that students possess
some knowledge of and experience with relational databases. SQL Server knowledge/experience
will be more helpful than experience and knowledge with other technologies.
DAY 1
Lesson 0: Introduction
·
Training
Overview, Expectations, and Introductions
Lesson 1: Creating Your First SSIS
package
·
Introduction
to Business Intelligence Development Studio
o
Visual Studio tips and tricks, menu contents
and locations
o
Exercise:
Create an SSIS Project
Lesson 2: Introduction to the Data
Flow Task
·
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
DAY 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: The Control Flow
·
Containers,
Precedence, and Workflow
o
Transactions, restart-ability, and blocking
o
Exercise:
Sequence Containers
DAY 3
Lesson 6: 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 7: Security, Deployment, and
Execution
·
SSIS
Package Deployment Options and Security Implications
o
Execution
options
o
Exercise:
Package Execution Options
Lesson 8: 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
Instrumentation
o
Exercise: Trapping and Logging Errors, Part 2