SSIS Tutorial Part 39-How to Use Row Count Transformation to Log Record Count in SSIS Package

In this video you will learn how to get the insert row count and log into audit table for SSIS Package. This is real time scenario that we use to log different type of row counts such as insert, update, delete to log table for each SSIS Package execution.

The video also covers
How to create an SSIS Package
How to use Data Flow Task in SSIS Package
How to create Audit Table for SSIS Package Execution
How to use Flat file Source to read text file in SSIS Package
How to load data to a table in SSIS Package
How to create variables in SSIS Package
How to store Insert row count in a variable in SSIS Package
How to use Execute SQL Task in SSIS Package
How to Map parameters for Insert statement in Execute SQL Task in SSIS Package
How to use Data Flow Task with Source and Destination in SSIS Package


Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
http://www.techbrothersit.com/2014/12...