The foundation for getting started in SQL Server Integration Services is a package. This file or object is the container of the data transformations built for moving data from a source to a destination. In this course, Building Your First SSIS 2016 Package, you’ll gain the ability to navigate the important areas for using SQL Server Data Tools to design, manage, and deploy SSIS packages. First, you’ll explore the development tool for managing SSIS packages in projects. Next, you’ll discover the data flow area will be used to move data from source to destination in the main canvas or control flow. Many components or tasks will be used in a data flow that are common for extracting, transforming, and loading (ETL) data. Finally, you’ll see the management of a deployment and execution of a package is demonstrated step by step. When you’re finished with this course, you’ll have the skills and knowledge of developing SSIS packages needed to loop through sources, move data, and process tasks with automation.
Author Name: Thomas LeBlanc
Author Description:
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.

Table of Contents

• Course Overview
  1min
• Planning Data Integration Using SSIS
  22mins
• Managing SSIS Projects
  19mins
• Extract and Transform Data
  26mins
• Loading Data
  26mins
• Configure and Deploy SSIS Packages
  17mins
• Summary
  2mins