Enterprise Extraction, Transformation and Loading with SQL Server 2005 Integration Services

4 Day Course
Code SQLSSIS05

This course has been retired. Please view currently available SQL Training Courses.

Modules

Hide all

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

Prerequisites

This course is intended for IT Professionals that are responsible for designing, developing, deploying, and operating business intelligence solutions. The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the new capabilities provided by SSIS to build ETL or other data integration type solution. While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with SQL Server 2000 DTS.

Sections