4.1 out of 5
138 reviews on Udemy

Mastering the Fundamentals of SSIS

A Practical Guile To SQL Server Integration Services
Mike West
691 students enrolled
English [Auto-generated]
At the conclusion of this course you'll understand how the SSIS works at a very high level.
You'll be able to craft high performing SSIS packages.
You'll understand all the various components of the SSIS Designer.

SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.

We will also sort out the various versions and name changes. For example, in SQL Server 2014 Microsoft decided to no longer include SQL Server Data Tools (Another Visual Studio shell for SSIS) as part of the normal install. This confused everyone. To make matters worse, you now download and install different tools depending on what you have already.

This course will provide you with a solid foundation of SQL Server Integration Services. We will cover everything from the designer to crafting high quality packages.

While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just Data warehousing approaches.

For example, when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created.

You’ll learn all the vernacular associated with SSIS as well as all the core components.

We’ll cover the package in detail. The package is the unit of work that is retrieved, executed, and saved.

At a high level, SSIS provides the ability to retrieve data from just about any source, perform transformations on data, covert data from one type to another, load data into just about any source and define complex workflows that move disparate data throughout any organization.

In this course you’ll learn how to use SSIS to develop data integration, migration and consolation packages that you as a DBA or developer can use in any organization that has data.

In the course we will cover the integration with other SQL Server products like SSMS. SQL Server Management Studio provides the Integration Services service that you use to manage packages, monitor running packages, and determine impact and data lineage for Integration Services and SQL Server objects.

I look forward to seeing you in the course.

Join Now!!!!!

Intro to SQL Server Integration Services

Welcome To Mastering the Fundamentals of SSIS

This is a brief introduction to the course.

Is this Course Right for You?

Are you in the right place?

I want to make sure you are taking the correct course for your needs.

Course Downloads

This is where you'll download the content for the course.

Where did BIDS or SSDT go?

Microsoft really botched this one up. Let's find out the most recent name and location for SSDT.

Installing SSDT

In this lecture let's install SSDT. 

Installing Adventureworks Training Database
The SSIS Designer

Let's cover the interface we will be spending a lot of our time in.

It's very intuitively designed.


In this lesson let's define a package and determine how it relates to SSIS.

SSIS Wizard. Moving Data Was Never So Easy.

SSIS comes with an Import/Export wizard that assists you with crafting simple packages.

The Project and the Solution

The foundation of our package will be built within projects.

These projects ride with solutions.

Let's cover that in detail in this brief lecture.

Our Very First SSIS Package. Learning what tasks do.

Let's learn the basics of tasks and use them to create a very simple SSIS package.

Integration Services Service

What does the service that runs SSIS really do?

Let's find out in this lesson.


Let's wrap up what we've covered in this section.


Let's go over some of the new vernacular associated with the SSIS environment.


Core SSIS Features - Control Flow

The Data Flow Task

The most famous and important of all tasks.

Let's cover what he does.

Defining The Most Common Tasks

Let's walk through some of the task we use most often.

Some of them, like the data flow task you'll use on almost every single package.

The Bulk Insert Task

Not my favorite task but it's there if we need it.

Connection Manager

The Connection Manger is where we house our connections to the various data sources we use in our SSIS packages.

Let's look at the two places where we can view these connections.

The Execute Package Task

Let's call a package from another package.

It's nice to have to create more complex workflows.

The Execute Process Task

Let's discuss a way we can call other programs from within SSIS.

The File System Task

Easily one of my favorite tasks.

This one was way overdue and it's nice to have.

The Send Mail Task

Having our SSIS packages communicate with us is nice.

We can also send out attachments.

This is a great task you'll use often.

The ForEach Loop Containter

Containers are a little more complex and require some additional configuration but their usefulness outweighs the added learning curve.


Let's wrap up what we've covered in this section.


Core SSIS Features - Data Flow

The Conditional Split Transformation

Conditional split is used to route data rows to different outputs based on conditions. This is similar to CASE statement in programming languages.

The Aggregate Transformation

The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output.

Derived Column Transformation

The Derived Column transformation creates new column values by applying expressions to transformation input columns.

The Merge Transformation

In the current release of SQL Server Integration Services, the SQL statement in an Execute SQL task can contain a MERGE statement.

The Odata Transformation

You use the OData Source component in an SSIS package to consume data from Open Data Protocol (OData) services.

The Multicast Transformation

Sometimes it's required to have multiple logical copies of source data of a single source table either for applying different transformation logic on each set or having each dataset for separate consumers, Multicast transformation helps to do this.

Execute Package Utility

The dtexec command prompt utility (dtexec.exe) can be used to run a SSIS package.

Package Protection Levels

To protect the data in an Integration Services package, you can set a protection level that helps protect just sensitive data or all the data in the package.

Importing an Excel Document

In this lesson let's walk through importing an excel spreadsheet into SQL Server. 


Let's wrap up what we've learned in this section.



Final Words and a Thank You!!!

You've completed this course on the fundamentals of SSIS. Congratulations and thank you!!!

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1 out of 5
138 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


2 hours on-demand video
7 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion