Post reply

How do you count the errors and put the row number of the error into a flat file destination

  • April 20, 2007 at 4:32 am

    #177712

    I have a folder which has 40 or so text files all of the same format, I have a Foreach loop container going through this folder and entering data into a database table in management studio. When i have an error within this data I have made sql tell me which text file it is using flat file destination, derived column.

    I want it to also tell me which row the error is on within that text file

     

    Can anyone help me please????

  • April 21, 2007 at 9:47 pm

    #701851

    I haven't payed around with it at all but have noticed the Row Count(er) in the Toolbox when working in the DataFlow. Possibly you could find a way to put it in to your data flow to get an idea of the erroring row?

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply