Integration Services Fundamentals

Ready to learn SSIS? This course is for business intelligence developers, database professionals & those with no prior experience with Integration Services. Sign up now!

This course explains how to develop Integration Services 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 and shows how these tasks can be performed sequentially or in parallel in the control flow by using precedence constraints. Then the course 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 debug packages, configure logging, manage transactions, and manage package restarts. It also describes how to automate the execution of packages. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics also apply to earlier versions of Integration Services.

• 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