In this step by step SSIS Tutorial I will show you how to use SSIS Row Count Transformation. For the purpose of this tutorial I will use SSIS 2012. There are a few main changes comparing to previous version of SSIS But the principle staying the same.
VIDEO: This is text based tutorial for video tutorial see Video SSIS Row Count Transformation
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
- SQL Server 2008 / R2
- The examples we used should work in SQL Server 2008 and R2
- SQL Server 2005
- We suspect that this will work in SQL Server 2005 as well
The Row Count Transformation allows us to count rows that passed though the transformation and record it in a variable.
So I have got Data Flow Task with connection to AdventureWorksDW2012 .
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month