jump to navigation

Introduction of SQL Server Integration Services – A Tutorial article January 7, 2009

Posted by Arshad Ali in SQL Server Integration Services, SSIS, SSIS 2008.

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.



1. Harshad - October 26, 2009

Hi Arshad,Im Harshad from chennai im nt able to read ur aticles in sqlserverperformance abt integration services as the site is throwing exception can u please some other source to read the same

2. Arshad Ali - December 2, 2009

Please check and let me know if you still find issue in opening the links.http://www.sql-server-performance.com/articles/Arshad_Ali.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: