A Practical Guile To SQL Server Integration Services

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.