Scribd
Upload
88 views2 pages

Courtesy:: Lesson 1: Create A Project and Basic Package With SSIS

This document introduces a course on using SSIS (SQL Server Integration Services) to perform ETL (extract, transform, load) processes. The course contains 6 lessons that build upon each other to create an SSIS package that extracts data from multiple flat files, transforms the data using lookups, loads the results into a database, adds logging and error handling, and utilizes configurations and parameters. The lessons introduce looping, logging, error handling, configurations, and parameters in SSIS. The goal is to help students learn how to use the new features in SSIS to create an ETL package.

Uploaded by

Amine Hamdouchi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
88 views2 pages

Courtesy:: Lesson 1: Create A Project and Basic Package With SSIS

This document introduces a course on using SSIS (SQL Server Integration Services) to perform ETL (extract, transform, load) processes. The course contains 6 lessons that build upon each other to create an SSIS package that extracts data from multiple flat files, transforms the data using lookups, loads the results into a database, adds logging and error handling, and utilizes configurations and parameters. The lessons introduce looping, logging, error handling, configurations, and parameters in SSIS. The goal is to help students learn how to use the new features in SSIS to create an ETL package.

Uploaded by

Amine Hamdouchi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Preface:

Welcome to this course on “Learn ETL using SSIS”.


This course is a part of the Microsoft Business Intelligence Stack.
In all the courses, I have used commonly available free databases, so that you can
follow along with me. It been really a pleasure for me teaching 100,000+ student
enrollments and answering 10’s of 100’s of questions every day.
Hope you all enjoy this ETL course.
Courtesy: https://docs.microsoft.com/en-us/sql/integration-services/ssis-how-to-create-an-etl-
package

In the videos, I have walked you all through some examples, which will help you
solve the below exercises. The below problem set is derived from the MSDN
website. I have designed the whole course so that you can solve the below
problems easily. Please note that some of the concepts will require you to read
and web search a bit or take the advanced SQL course. Always feel free to ask
questions in the forums.

This tutorial gets you acquainted with the new tools, controls and features
available in Microsoft SQL Server Integration Services is to use them. This tutorial
walks you through SSIS Designer to create a simple ETL package that includes
looping, configurations, error flow logic and logging.

Lesson 1: Create a Project and Basic Package with SSIS


In this lesson, you will create a simple ETL package that extracts data from a single
flat file, transforms the data using lookup transformations and finally loads the
result into a fact table destination.

Lesson 2: Adding Looping with SSIS


In this lesson, you will expand the package you created in Lesson 1 to take
advantage of new looping features to extract multiple flat files into a single data
flow process.

Lesson 3: Add Logging with SSIS


In this lesson, you will expand the package you created in Lesson 2 to take
advantage of new logging features.+

pg. 1 www.rakeshgopal.com
Lesson 4: Add Error Flow Redirection with SSIS
In this lesson, you will expand the package you created in lesson 3 to take
advantage of new error output configurations.

Lesson 5: Add SSIS Package Configurations for the Package Deployment Model
In this lesson, you will expand the package you created in Lesson 4 to take
advantage of new package configuration options.

Lesson 6: Using Parameters with the Project Deployment Model in SSIS


In this lesson, you will expand the package you created in Lesson 5 to take
advantage of using new parameters with the project deployment model.

Complete PDF: https://docs.microsoft.com/pdfstore/en-us/SQL.sql-


content/live/integration-services.pdf

pg. 2 www.rakeshgopal.com

You might also like