Tuesday, December 23, 2008

Row Count Transformation as Destination

Found that using Row Count Transformation as temporary destination to try out different options in my mapping was really useful. When i am satisfied with my data flow, i can remove add the real destination.
All i had to do was create two variables to hold the count. Here is a sample flow.