SQL Server Integration Services an Introduction

January 6, 2009

[From SQL Server Performance]

SQL Server Integration Services (SSIS) is a platform for building high performance data integration and workflow solutions. It allows creating packages or SSIS packages which are made up of tasks that can move data from source to destination and if necessary alter it on the way.

SSIS is basically an ETL (Extraction, Transformation, and Load) tool whose main purpose is to do extraction, transformation and loading of data but it can be used for several other purposes for example, to automate maintenance of SQL Server databases, update multidimensional cube data etc as well.

The article continues at http://www.sql-server-performance.com/articles/biz/SSIS_Introduction_Part1_p1.aspx