Thursday, November 29, 2007

SSIS - Am I Overlooking Something?

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?

No comments: