55321 SQL Server Integration Services

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led 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.

Course Details

Price:

$2,995.00

Days:

Location:

Course Overview

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

Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design.

Module 1: SSIS Overview

Import/Export Wizard and Exporting Data
Common Import Concerns and Quality Checking Data

Module 2: Working with Solutions and Projects

SQL Server Data Tools Overview
Understanding Solutions, Projects, and Visual Studio Interface

Module 3: Basic Control Flow

Working with Tasks, Precedence Constraints, and Connection Managers
Annotating, Grouping, and Managing Package/Task Properties
Favorite Tasks for Common Scenarios

Module 4: Common Tasks

Analysis Services Processing and Data Profiling
Execute Package/Process Tasks and Expression Tasks
File System, FTP, and Hadoop Tasks
Script Task Basics, Send Mail, Web Service, and XML Tasks

Module 5: Data Flow Sources, Destinations, and Transformations

Data Flow Task and SSIS Toolbox Overview
Working with Data Sources and Destinations (Databases, Flat Files, Excel)
Configuring Transformations to cleanse and shape data

Module 6: Making Packages Dynamic

Parameters (Package, Project, SQL) and Variables
Using Expressions in Tasks and Connection Managers
Post-Deployment Dynamic Configurations

Module 7: Containers

Sequence Containers, For Loops, and Foreach Loops

Module 8: Troubleshooting and Package Reliability

Error Handling: Redirecting Rows, Logging, Event Handlers
Using Breakpoints, Checkpoints, and Transactions
Managing MaximumErrorCount for Stability

Module 9: Deploying to the SSIS Catalog

Understanding the SSIS Catalog and Deployment Models
Deploying Projects, Managing Environments, and Executing Packages (SSMS, Command Line)

Module 10: Installing and Administering SSIS

Installing and Upgrading SSIS
Managing the Catalog, Built-in Reports, Logging, and Operation Histories
Automating Package Execution

Module 11: Securing the SSIS Catalog

Principals, Securables, and Permissions Management
Granting Permissions and Configuring Proxy Accounts

Class Dates & Times


01/25/2027 - 01/29/2027 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
07/27/2026 - 07/31/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
09/28/2026 - 10/02/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →