19-Apr-2014SQL 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.
13-Mar-2014SQL SERVER: SSIS - Look Up Transformation Task
oday, I am going to give basic example of Lookup Transformation Task in SSIS.
Lookup transformation performs lookup operation by joining data in input columns with reference table dataset columns.Lookup can be used to access addition information from the reference dataset based on the matching criteria Reference dataset can be OLEDB table, Excel file or cache file, or SQL query result.
22-Oct-2009SQL SERVER SSIS: Basic Example Of Data Flow Task
Today I am going to give Basic example of Data Flow Task in SSIS, import CSV file to SQL SERVER Database
Many times user asked to import their data from their files. They might have data in Microsoft Access, Microsoft Excel, CSV File, Text Tile etc..