I'm currently working on a project that involves a couple of SSIS Packages. There's something that seems like it should be simple to do, yet I haven't found a clean way to do it yet: I want to add a column to a Flat File Source when reading the file in a Data Flow that stores the line number for each record from the flat file. The flat file's records are delimited by CR-LF.
There is a RowCount Task that seems like it shouldn't do what I want but I don't see many other option over creating custom scripts and variables.
Is there something simple I'm overlooking here?