Search results for: Data Transformation
19-Apr-2014
SQL SERVER: SSIS – Merge Join Transformation
Now, let’s have a look at functionality of Merge Join Transformation task in SSIS. Benefit of using Merge join is, input datasets can be combination of any two datasets from (Excel file, XML file, OLEDB table, Flat file).Output can be result of INNER, LEFT Outer, or FULL Outer Join on both the datasets. Merge Join Transformation has two inputs and one output. It does not support an error output.
SSIS For Each Loop Container II_thumb[1].jpg)
11-Jan-2010
SQL SERVER: SSIS - Derived Column Data Flow Transformation
As I explained earlier about Foreach Loop Container. One of regular reader of blog send me an email about one issue.
