SQL Server Integration Services Tutorial by MSSQLTIPS.com

Guys,

SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. Extract, Transform and Load data. While ETL processing is common in data warehousing (DW) applications, SSIS can do much more than that e.g. when we create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created, when we export or import data, an SSIS package is created.

At a high level, SSIS provides the ability to:

• Retrieve data from just about any source
• Perform various transformations on the data; e.g. convert from one type to another, convert to uppercase or lowercase, perform calculations, etc.
• Load data into just about any source
• Define a workflow  

In this tutorial we will step through a number of topics that we need to understand in order to successfully build an SSIS package. Our high level outline is as follows:

• Creating SSIS packages with SQL Server Management Studio (SSMS)
• Business Intelligence Development Studio (BIDS)
• Creating a simple SSIS package in BIDS
• Deploying SSIS packages
• Executing SSIS packages

Click here to read tutorial.

 

Happy learning

 

Sudhir