Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Building Your First SSIS Package

via Pluralsight

Overview

This course will help you learn to develop SSIS packages to be able to loop through sources, move data, and process tasks with automation.

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.

Taught by

Thomas LeBlanc

Reviews

3.9 rating at Pluralsight based on 89 ratings

Start your review of Building Your First SSIS Package

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.