Post reply

Best way to identify offending row(s) in ssis package

  • August 9, 2010 at 4:03 am

    #222287

    Hi,

    I have been given a ssis packace that inserts records from a csv file into a sql 2005 database. The file contains many 1000's of rows. When I run the package I see in the debug output window errors occur, the erros are:

    Cannot insert duplicate key row in object 'dbo.Users' with unique index 'Users_UserName_Idx'.

    The package is set to continue until it reaches the end of the file, however I'd like to know what would be the best way to get the ssis package to show me the row(s) that are causing this error. Any suggestions would be greatly appreciated.

    thanks

  • August 9, 2010 at 4:27 am

    #1204048

    On your destination component, set the error output to send any errors to an error data flow.

    Connect the error data flow to a flatfile or table and then run the package and the offending row should get sent to the error output

  • August 9, 2010 at 8:19 am

    #1204188

    thanks.

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

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