Home ┬╗ SSIS

SSIS

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

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

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

 1,424 total views,  5 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,144 total views,  4 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

 1,195 total views,  9 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

 2,977 total views,  10 views today