Basics of SSIS (Sql Server Integration Services)

With the Release of the SQL Server 2005 a new and Advance form of the DTS has been launched and it is named as SQL Server Integration Service, Basically SSIS is a complete ETL (Extraction Transformation and Loading) tool.
It is very interesting to know that without writing even a single line of Code you can perform many complex tasks like :

• Data Bulk-Insert from Flat file to Sql Server Database.
• Email Notifications.
• Manipulation of the data.
• Data Transfer from Hetreogenous Data sources to SQL Server database.
• SQL Server Administrative task and much more..

There are major three main modules of the SSIS

1. Control Flow
2. Data Flow
3. Event handlers

Each of them play a vital role in the development of the ETL operations required for your organization.
Other Component of the SSIS are :

• Connection object. This is mainly for the setting connections to the Destination and Source Database.
• Transformation Objects:  These tasks objects helps you to convert the source data from one form to another in desired format.
• Source and Destination Databases/Flat Files: This is self explanatory.
• Notification Tasks:  Like Email Notification task etc.
• FTP task and much more..

This was just to give you the glimpse of the SSIS : A basic Introduction., In later blogs you will find detailed analysis of each and every component.