Building Your First SSIS Package

This course will help you learn to develop SSIS packages to be able to loop through sources, move data, and process tasks with automation.
Course info
Rating
(20)
Level
Beginner
Updated
Jun 26, 2020
Duration
1h 55m
Table of contents
Course Overview
Planning Data Integration Using SSIS
Managing SSIS Projects
Extract and Transform Data
Loading Data
Configure and Deploy SSIS Packages
Summary
Description
Course info
Rating
(20)
Level
Beginner
Updated
Jun 26, 2020
Duration
1h 55m
Description

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 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.

About the author
About the author

Microsoft Data Platform MVP specializing in SQL Server, Microsoft Business Intelligence (SSIS, SSAS & SSRS) and Power BI.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Thomas LeBlanc, and welcome to the course building your first s s. I s package. I'm a data warehouse architect in Baton Rouge, Louisiana, and I enjoy spending my workday around data in this course we're going to traverse the stack of sequel server integration services are S s I s for Microsoft. The extract transform and low tool has been a go to for DB a data and data Warehouse Architects, as was his business intelligence developers for over a decade. This course will explain areas in the tools for creating Ronnie testing and deploying SS I s packages. Some of the major topics we will cover include using sequel server data tools understanding the difference between a control and a data flow, including transformation components to massage the data sharing connections and parameters between a projects packages. Finally, we review the preferred deployment techniques. By the end of this course, you will be able to use the tools for executing a package t e t l data from a source system to a destination as well as monitor the progress before beginning this course, you should be familiar with sequel server database, engine understanding the structure of a C S V. File and executing T sequel with Sequel Server. I hope you join me on this journey toe learn sequel server integration services with building your first S s I s package course at Plural side.