Home >
SQL Server >
Advanced SQL Server 2005 Integration Services (SSIS)
Advanced SQL Server 2005 Integration Services (SSIS)
| Course Code: |
SQSAIS |
| Duration: |
4 days |
| Audience: |
SSIS architects, SSIS developers and SQL Server 2005 DBAs. |
| Prerequisites: |
Completion of our course SQL Server 2005 Integration Services
or equivalent knowledge. |
| Summary: |
This advanced SSIS presentation emphasises some of the
more advanced concepts and features of SQL Server 2005
Integration Services (SSIS) including performance and best practices:
- SSIS engine
- Data Flow Engine and Control Flow optimization
- Control Flow - detailed
- Data Flow - detailed
- Containers - detailed
- Expressions
- Variables - detailed
- Fuzzy Lookup - detailed
- Advanced transformations
- Advanced error and event handling
- SSIS problem determination
- Transaction Management (e.g., checkpoint, RESTART)
- Concurrency and snapshot isolation
- A comprehensive case study (the main feature)
- Etc.
|
| Objectives: |
Upon completion of this course, the participant should be able to
exploit and expand SSIS built-in, and customised, facilities to develop ETL
solutions per the topics outlined under 'Core Topics' in the detailed outline.
|
| Format: |
Lecture and hands-on.
|
Detailed Outline |
|