SSIS : How do I add rownumber/line number to a data flow
There are a number of options to achieve a row number
/line number in a data flow.
One of the easiest solutions is to use script component.
This video shows you how to,
http://sqlblogcasts.com/files/folders/ssis_tools/entry1591.aspx
-