Tuesday, May 24, 2011

SQL Server Integration Services Tutorial by MSSQLTIPS.com


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

Happy learning

No comments: