Conditional Split Transformation in SSIS

The Conditional Split transformation moves data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is… Read More »Conditional Split Transformation in SSIS

 2,598 total views,  1 views today

Merge Transformation in SSIS

The Merge transformation in SSIS combines two datasets into a single dataset. It takes two datasets and must be in sorted order, so the output… Read More »Merge Transformation in SSIS

 1,900 total views,  1 views today

SSIS Connection Managers

SSIS connection managers are used to configure a connection between source and destination data stores such as Excel, Text, XML, FTP, Relational databases and so… Read More »SSIS Connection Managers

 3,163 total views,  4 views today

Derived Column Transformation in SSIS

The Derived Column transformation in SSIS allows us to create new column values by applying expressions to transformation input columns. An expression can be created… Read More »Derived Column Transformation in SSIS

 6,566 total views,  8 views today

Create a new SSIS project

This article demonstrate how to create a new SSIS project using SSDT (SQL Server Data Tool). SSIS projects are created to transform data from a… Read More »Create a new SSIS project

 1,940 total views,  2 views today