This course addresses the technical skills required to Extract, Transform and Load (ETL) data using SQL Server Integration Services. Course topics include how to create, edit, deploy, schedule and manage Integration Services packages; configuring control flow, data flow and event handling tasks within an Integration Services package; and implementing logging and error-handling during package execution. 

• Structured Query Language (SQL): Level 1 or equivalent knowledge 
• Beginning SQL Server or equivalent knowledge

Lesson 1  

Implement an Integration Services Package 

• SSIS overview 
• Identify components 
• Tools that are used to build and manage Integration Services solutions 

Lesson 2  

Implement an Integration Services Package 

• Create OLEDB Connection Managers 
• Import data from a SQL database into another 
• Create Control Flow Tasks and Sequence Containers 

Lesson 3  

Implement an Integration Services Package 

• Create constraints between Tasks and Sequence Containers 
• Skill check for Objective 1 

Import data to a SQL database using Data Flow Tasks 

• Create a Data Flow Task that uses a Flat File 
• Import from a text file into a SQL database 

Lesson 4  

Import data to a SQL database using Data Flow Tasks 

• Import from an Excel spreadsheet 
• Create an Execute SQL Task that calls a stored procedure 
• Create an Execute SQL Task that calls a query 

Lesson 5  

• Import data to a SQL database using Data Flow Tasks 
• Create child packages that are called by parent packages 
• Skill check for Objective 2 
• Manage an Integration Services package file 
• Apply built-in error handling to an existing package 

Lesson 6  

Manage an integration Services package file 

• Implement transactions in an SSIS package 
• Implement checkpoints in an SSIS package 
• Skill check for Objective 3 

Lesson 7  

Interact with SQL Server 2014 SSISDB and administrative reporting tools 

• Set up the SQL Server SSISDB catalog 
• Deploy a Project Deployment Model project 

Lesson 8  

Interact with SQL Server 2014 SSISDB and administrative reporting tools 

• Interact with SSISDB Environment and Parameters 
• Interact with SQL Server’s built-in reporting tools 
• Skill check for Objective 4