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
(1326)
Level
Beginner
Updated
Jun 6, 2011
Duration
7h 1m
Table of contents
Introduction to Integration Services
Control Flow Basics
Control Flow Tasks
Data Flow Basics
Data Flow Transformations
Expressions
Scripts
Debugging SSIS Packages
Package Reliability
Package Execution
Description
Course info
Rating
(1326)
Level
Beginner
Updated
Jun 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.

Course FAQ
Course FAQ
Why do we use SSIS?

We use SSIS mostly for data warehousing purposes. It is very effective for data extraction, transformation, and loading (ETL). SSIS can also help automate SQL Server database maintenance, update data, and other useful functions.

What will I learn in this course?

You will learn:

  • how to develop Integration Services packages
  • data warehousing
  • how to use precedence constraints
  • how to extract, transform, and load processes
  • Integration Services expression language and scripting
  • how to debug packages
  • how to automate package execution
  • and much more
What version of software do I need?

This course and its concepts are based on the SQL Server 2008 R2 release, but most of the topics can apply to earlier or newer versions as well.

Are there prerequisites to this course?

Nope! This course is for beginners and assumes no previous training or exposure to SQL Server Integration Services (SSIS). The course is, however, intended for database professionals and/or business intelligence developers or those aspiring to be such.

Is SSIS free with SQL Server?

When you purchase a SQL Server license, a free SQL Server Integration Services license is included. If you don't have a SQL Server license then pricing ranges quite a bit depending on if you use Express and Developer editions, or Enterprise.

Is SSIS worth learning?

It may be a bit difficult, and some things that seem simple are not always so, but yes, it is worth learning! Especially if you are building complicated ETL packages across different systems, and/or if you work in a Microsoft shop.

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
Building Multidimensional Models in SSAS
Beginner
3h 52m
Dec 26, 2019
Building Your First Power BI Report
Beginner
1h 37m
Jun 3, 2019
Modeling Data in Power BI
Beginner
4h 57m
Mar 29, 2019
More courses by Stacia Misner Varga