Tim Mitchell
Follow Tim Mitchell on Twitter  Like Tim Mitchell on Facebook  Subscribe on YouTube  Connect on LinkedIn  Subscribe to the Data Geek Newsletter

Introduction to SSIS

SQL Server Integration Services is one of the most popular extract-transform-load (ETL) tools on the market. Learning how to use SSIS to move and transform data is an essential skill for every data professional, whether you’re a DBA, SQL Server developer, data analyst, or architect.

Classroom Training: Introduction to SSIS

Introduction to SSISThis 3-day hands-on course will teach you what you need to get started using SSIS to create reliable and reusable SSIS packages.

Among the topics covered in this course:

  • Overview of SSIS
  • Exploring the tools used for package building and management
  • Control flow
  • Data flow
  • Using sources and destinations to move data
  • Using transformation components to cleanse and reshape data
  • Dynamic behaviors using parameters, variables, and expressions
  • Using scripts in SSIS
  • Working with the SSIS catalog
  • Deploying and executing SSIS packages
  • Logging basics

This class is highly interactive and includes numerous classroom exercises to help build hands-on skills in addition to learning theory.

This Introduction to SSIS course is designed for the data professional with some experience with SQL Server (including T-SQL). No prior knowledge of SSIS is required.