Post reply

Count number of records that failed and were written to a bad file

  • June 26, 2008 at 11:32 am

    #381379

    Is there a way to count or retreive the count of number of records which failed to make it a sql server table for whatever and were routed to a flat file connection?

    I would like to write that count to a table. thanks

  • June 30, 2008 at 12:40 pm

    #836314

    I would imagine that if you just put a rowcount in front of your error file dest you can retrieve the var that holds that count in the next step and put that number in a table...

    So the flow would look something like this, right???

    OledbError==>rowcount==>errorFile

    Then in the next step, it would just look at the var from the rowcount.

    This should all be pretty easy.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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