Enterprise Extraction, Transformation and Loading with SQL Server 2005 Integration Services
This course has been retired. Please view currently available SQL Training Courses.
Learning SSIS Features and Functionality (1 topic)
- The initial seminar modules will dive deep into the core feature set of SSIS to lay the foundation for leveraging the tool for data processing requirements.
Transferring DTS 2000 Skills to Integration Services (1 topic)
- Preparation, migration, and redesign of DTS packages to SSIS will enable DTS users the ability to translate skills from SQL Server 2000 to SQL Server 2005 and provide keys to up-scaling SQL Server 2000 DTS based-solutions to SSIS. A prior knowledge of DTS is not essential for this section as the focus will be on SSIS architecture principles
Understanding and Applying ETL Concepts in SSIS (1 topic)
- Building on the SSIS knowledge, the focus will turn to understanding relational data warehousing principles- applying efficient SSIS processing techniques for dimensions and fact table ETL. Additionally, the seminar will consider processing architectures for loading SSAS dimension and cubes.
Deploying and Administering SSIS in Production (1 topic)
- The final modules cover getting ETL solutions over the goal line and maintaining sanity once there-focusing on deployment and ongoing administration