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

Course Schedule