Integration Services Fundamentals

This course is for business intelligence developers and database professionals responsible for moving, manipulating, and integrating data and assumes no prior experience with Integration Services
Course info
Rating
(1275)
Level
Beginner
Updated
June 6, 2011
Duration
7h 1m
Table of contents
Expressions
45m 34s
Scripts
23m 21s
Description
Course info
Rating
(1275)
Level
Beginner
Updated
June 6, 2011
Duration
7h 1m
Description

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.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Getting Started with Power BI
Beginner
3h 14m
23 Jun 2016
Building Blocks of Biml
Beginner
4h 10m
29 Dec 2015
More courses by Stacia Misner Varga