Info: Sort and Merge Components vs. Lookup Component

Worth reading this article..

http://consultingblogs.emc.com/jamiethomson/archive/2005/10/21/2289.aspx

Learn SSIS : Dataflow Transformation Categorization..

-->

Before anyone starts learning/designing data flow in SSIS, one should know what is been offered by Microsoft in SSIS toolbox. Most people don't know how many transformations are actually available in data flow and they choose some alternative workaround to performs operations which can be done easily using available transformations. In this article i am going to provide just a brief of all the transformations available in dataflow and categorise them. After reading this article one should be aware of what is been offered in SSIS designer, and it will be helpful for all those beginners to become aware of available transformations.

Also Categorization helps us to remember transformations, as there are lot.. its difficult to remember :)

Ok so lets start...

Transformations are divided into four categories

1. Row level  transformations
2. Rowset transformations
3. Multiple Input-output transformations
4. Advance Transformations.

Learn SSIS : MERGE, MERGE JOIN and UNION ALL

Well its looks I really getting fond of writing blogs. I think everyone should at least give a try writing blogs once :)

Today I am going to study some of the Dataflow transformations, MERGE, MERGE JOIN, and UNION ALL.

Yes the first question any SQL SERVER developer can ask is, these operations can very well be done in T-SQL query, Why using it in SSIS?, well the answer is, T-SQL can be used only when you are working with data which resides in SQL SEVER Tables, but what if the data is coming from different database itself like ORACLE or MYSQL or Flat File or XML or EXCEL.