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.
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.
