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
3,746 total views, 2 views today
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
4,009 total views, 2 views today
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
11,300 total views, 5 views today
This article demonstrate how to load data from Excel file into SQL Server table using SSIS. Lets see step by step implementation of simple basic… Read More »Load data from Excel file to SQL Server table using SSIS
7,297 total views, 1 views today
This article demonstrate how to load flat file into SQL Server table using SSIS. Lets see step by step implementation of simple basic SSIS package… Read More »Load flat file into SQL Server table in SSIS
9,140 total views, 2 views today