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.

Row Count transformation in SSIS

The Row Count transformation counts rows as they pass through a data flow and stores the final count in a variable. Row Count Transformation does not… Read More »Row Count transformation in SSIS

 1,293 total views,  1 views today

Aggregate Transformation Basic Mode in SSIS

The Aggregate transformation applies aggregate operations such as maximum, minimum, average, sum, and count to column values and copies the results to the transformation output.… Read More »Aggregate Transformation Basic Mode in SSIS

 2,243 total views,  2 views today

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,372 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,751 total views,  3 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

 2,630 total views,  3 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

 5,538 total views,  6 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,714 total views,  1 views today