This course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

After completing this course, you will be able to:
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog

Course Info

Not Your Location? Change

Cost: $ 3,275

Length: 5.0 days (40 hours)

Level:

Next Available Classes:

Schedule select
27
Mar
Monday
11:00 AM PT -
7:00 PM PT
Available
Schedule select
08
May
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
10
Jul
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
25
Sep
Monday
11:00 AM PT -
7:00 PM PT
Available
Schedule select
13
Nov
Monday
9:00 AM ET -
5:00 PM ET
Available
Loading...