SQL Server Integration Services (SSIS) is a platform for building high performance data integration and workflow solutions. It allows creating packages or rather SSIS packages which are made up of tasks that can move data from source to destination and if necessary alter it on the way. Not only this, it can be used for several other purposes for example, to automate maintenance of SQL Server databases, update multidimensional cube data etc as well.
In this article of 4 parts, I have discussed about SSIS at introductory level in details.
Part 1 - In this part, discussion is about the SSIS, its origin or brief history, SSIS Package and its components, different ways to create SSIS packages. Refer the link below for more details.
Part 2 – In this part, discussion is about the Data Flow Task in SSIS, different components which makes of data flow task, for example Transformation, Data Source Adapters, Data Destination Adapters and Data Paths. Refer the link below for more details.
Part 3 – In this part, discussion is about using Import and Export Wizard and SSIS Designer. At last we will go through some examples of creating SSIS packages. Refer the link below for more details.
Part 4 – In this part, discussion is about SSIS API Programming. We will create and execute a simple package programmatically using SSIS API Object Model.
http://www.sql-server-performance.com/articles/biz/SSIS_Introduction_Part4_p1.aspxIn the next article,
I am going to write more about the features and properties of SSIS for example Even Logging, Event Handlers, Transaction Support, Checkpoint Restart-ability and SSIS validation process. So stay tuned to see the power and capabilities of SSIS.