This course explains how to develop SQL Server Integration Services (SSIS) packages with an emphasis on the development of processes that support data warehousing.

It begins by describing the overall process of package development, then describes the types of tasks that Integration Services can perform and shows how these tasks can be performed sequentially or in parallel in the control flow by using precedence constraints.

Then the tutorial continues by reviewing the data flow components that are used for extract, transform, and load processes. In addition, the course covers the Integration Services expression language and scripting, and demonstrates how to:
Author Name: Stacia Misner Varga
Author Description:
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

Table of Contents

• Introduction to Integration Services
  32mins
• Control Flow Basics
  34mins
• Control Flow Tasks
  57mins
• Data Flow Basics
  48mins
• Data Flow Transformations
  72mins
• Expressions
  45mins
• Scripts
  23mins
• Debugging SSIS Packages
  33mins
• Package Reliability
  47mins
• Package Execution
  24mins