Skip to content
Home » SQL Server Integration Services

SQL Server Integration Services

SQL Server Integration Services is a data migration and integration tool that can extract and transform data from a wide variety of sources such as flat files, and relational data sources, and then load the data into one or more destinations.

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

 3,813 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

 2,616 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

 5,954 total views,  1 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

 10,588 total views,  2 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

 3,067 total views,  1 views today