OLE DB Command Transformation in SSIS

How To Use OLE DB Command Transformation [ Delete Rows in Data Flow Task] Scenario: We have a SQL table which contains our data. Every day we get a text file from our users  and they want to delete records from SQL table those match with the text file records those they have provided.  The...

Merge Join Transformation in SSIS

Merge Join Transformation is one of the useful tool in SSIS to join two sources. The Merge Join transformation provides an output that is generated by joining two sorted datasets using a FULL, LEFT, or INNER join. Let us see how it works.You can configure the Merge Join transformation in the following...

MERGE transformation in SSIS

In this post we are gonna discuss about MERGE transformation. MERGE in SSIS is equal to UNION ALL in SQL Server. This transformation unions two datasets/tables.The merge Transformation combines two sorted dataset into single dataset. Highlighted the text SORTED in last statement because...