How to Use Row Count Transformation to Log Record Count in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, 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

  1. How to create an SSIS Package 
  2. How to use Data Flow Task in SSIS Package
  3. How to create Audit Table for SSIS Package Execution
  4. How to use Flat file Source to read text file in SSIS Package
  5. How to load data to a table in SSIS Package
  6. How to create variables in SSIS Package
  7. How to store Insert row count in a variable in SSIS Package
  8. How to use Execute SQL Task in SSIS Package
  9. How to Map parameters for Insert statement in Execute SQL Task in SSIS Package
  10. How to use Data Flow Task with Source and Destination in SSIS Package



How to Use Row Count Transformation to Log Record Count in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)