I'm developing a ETL, that uses a FFCM to parse data from a csv and loads it in a SQL Server table.
Some float data aren't parsing properly, so I need to see the result in the table and get back to the flat file to see how it is there.
I'm reading the file in Notepad++, it would be much easier to find data if I had its line number.
Is it possible for FFCM/Flat File Source to add the line number to the list of columns, so I can save it in the table?
Best Answer
I found it!
http://weblogs.sqlteam.com/jamesn/archive/2008/02/13/60509.aspx
It's not a CCFM or a Flat File Source, but it works pretty fine and it's elegant.