SQL Server Integration Services SSIS 2016 Tutorial


SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration use cases or just to move data around. SSIS is used behind the scenes in the Maintenance Plans of SQL Server and in the Import/Export wizard.

SSIS is a flexible tool and it can perform all sorts of operations:

  • Transferring data from a source to a destination. This is done in memory and you can perform data manipulation tasks on the data while it is in memory, which makes SSIS one of the faster tools on the market.
  • You can perform simple FTP tasks.
  • SSIS can send emails to notify people.
  • SSIS is capable of robust error and event handling.
  • You can define a workflow with constrains to conditionally execute certain tasks.
  • And if all that isn’t enough, you can always extend SSIS with .NET code.

There’s already an Integration Services tutorial here at MSSQLTips.com. However, it’s already a couple of years old and there have been plenty of changes and new features for SSIS to warrant a new tutorial. In this tutorial, we will guide you with the creation of a simple package that transfers and manipulates data between a source and a destination. We will also deploy the package to the server and investigate how you can execute and monitor the package.

We will go through a number of topics in order to create our package. The high-level outline is as follows:

  • How to get Sample Data?
  • Control Flow
  • Reading Data
  • Writing Data
  • Deploying the Package
  • Executing the Package
  • Monitoring Execution
  • Quick Performance Tips

You can use the outline on the left to browse the tutorial or use the arrows “Previous” and “Next”.

Additional Information
  • You can find all SSIS tips here.

Comments For This Article

Monday, October 18, 2021 - 3:00:26 AM - Koen Verbeeck Back To Top (89338)
Hi Darshan,
except for the SSIS scale-out cluster and the SSIS IR runtime in ADF, there almost have been no changes in SSIS since the release of SQL Server 2016. And both those features are more admin/architecture related and not development. My opinion is that if you want to learn about developing SSIS packages, this tutorial will be OK.


Friday, October 15, 2021 - 12:08:44 AM - Darshan Joshi Back To Top (89333)
I've used SQL Server but never SSIS and SSAS. Do you know of any good up-to-date resources to learn SSIS?

Many of the Udemy & Pluralsight courses for SSIS don't seem to have been updated recently and I don't want to learn outdated stuff.

Friday, February 7, 2020 - 7:34:37 PM - Richard Holmes Back To Top (84255)

This was very helpful. TX.

get free sql tips
agree to terms