SQL Server Integration Services (SSIS)

Explore the technical skills required to Extract, Transform and Load (ETL) data using SQL Server Integration Services.

course image

Course details

ceus icon CEUs 2.4

schedule icon Schedule Weekends

location icon Location Online, North Campus

cost icon Cost

Registration details

SQL Server Integration Services (SSIS)

Explore the technical skills required to Extract, Transform and Load (ETL) data using SQL Server Integration Services.

What you’ll be able to do — competencies

  • Implement an Integration Services package  
  • Import data, from a relational data model and other data sources, to a SQL database using Data Flow Tasks   
  • Manage an Integration Services package file  
  • Interact with SQL Server 2014 SSISDB and administrative reporting tools 

Course description

expand drawer icon collaspe drawer icon

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. 

Prerequisites

expand drawer icon collaspe drawer icon
  • Structured Query Language (SQL): Level 1 or equivalent knowledge 
  • Beginning SQL Server or equivalent knowledge

Syllabus

expand drawer icon collaspe drawer icon

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 

Next available start dates

Online — Evenings

Registration closed expand drawer icon collaspe drawer icon
SQL Server Integration Services (SSIS)
hours icon

Total classroom hours

24 hours

schedule icon

Schedule

Online

Evenings, 6:30 PM - 9:30 PM, 9 T Th - 11/12/2020 - 12/15/2020, No class 11/26

cost icon

Total cost

$789

instructor icon

Instructor: Shankar Pal

Online — Evenings

Registration open expand drawer icon collaspe drawer icon
SQL Server Integration Services (SSIS)
hours icon

Total classroom hours

24 hours

schedule icon

Schedule

Online

Evenings, 6:30 PM - 9:30 PM, 8 T Th, 1/26/2021 - 2/18/2021

Quarter: Winter

cost icon

Total cost

$789

instructor icon

Instructor: Shankar Pal

notes icon

Notes

Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started