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.

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

 4,241 total views,  2 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

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

 7,405 total views,  1 views today