|Course Title||SQL Server Integration Services (SSIS)|
|Emploi-Québec fee (taxes incl.)
|General Public fee (taxes incl.)
|Prerequisites||SQL Level 2 or working knowledge of relational databases (database design skills|
|Target Audience||Participants interested in acquiring the knowledge and skills needed to implement Microsoft SQL Server Integration Services (SSIS)|
|Location||Brittain Hall – lab TBA|
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
SQL Server 2016 Integration Services Cookbook | Christian Cote | ISBN: 978-1786461827 © 2017 | Packt Publishing Limited.
Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
The primary objective of this course is to provide students with the knowledge and skills to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package. The created package takes then data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.
This course walks you through SSIS Designer to create a simple ETL package that includes looping, configurations, error flow logic and logging.
Topics to be covered:
Module 1 – Overview of SQL Server Integration Services
Overview of SSIS
Integration Services (SSIS) Development and Management Tools
Integration Services (SSIS) Projects and Solutions
Install/ Upgrade Integration Services
Change Data Capture (SSIS)
Integration Services (SSIS) Connections
Integration Services Containers
Integration Services Tasks
Module 2 – Create a simple ETL package
Create a Project and Basic Package with SSIS
Adding Looping with SSIS
Add Logging with SSIS
Add Error Flow Redirection with SSIS
Add SSIS Package Configurations for the Package Deployment Model
Using Parameters with the Project Deployment Model in SSIS
Module 2 – Deploy Packages with SSIS
Preparing to Create the Deployment Bundle
Create the Deployment Bundle in SSIS
Install SSIS Packages