Training
SQL Server Integration Services Tooling
SQL Server Integration Services is Microsoft's primary tool for ETL (Extract-Transform-Load) processing. This course is designed to take you through the most important aspects of how to use the SSIS tooling, with just the right amount of depth, within a single day.

The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

During the day, you'll gain confidence in using the tooling provided by SQL Server Integration Services for ETL (Extract-Transform-Load) processing. You'll learn how to create projects and packages and learn how to deploy and schedule them.

While our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.
City
Dates
Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Day
Code
Module
1
IS201
Overview of SQL Server Integration Services
- Integration Services Features Overview
- Working with SQL Server BI Tooling
- Creating SSIS Projects and Packages
- LAB: Creating SSIS Projects and Packages
1
IS202
Working with SSIS Control Flow
- Introduction to Control Flow Tasks and Precedence Constraints
- Working with Containers
- Passing Information Between Tasks with Variables and Expressions
- LAB: Working with SSIS Control Flow
1
IS203
Working with SSIS Data Flow
- Introduction to Data Flow Data Sources, Destinations and Assistants
- Transforming Data
- Debugging Using Data Viewers and Breakpoints
- LAB: Working with SSIS Data Flow
1
IS204
SSIS Configuration, Deployment, Scheduling and Logging
- Project and Package Configurations
- Deploying Projects or Packages
- Scheduling Package Execution
- Logging Package Activity
- LAB: SSIS Configurations, Deployment, Scheduling and Logging
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement