Post reply

Passing the error row to XML Column in database

  • September 25, 2014 at 8:49 am

    #397402

    I started to look at this some time ago and it is now time to pick this up again.

    What I am looking for is when in the data flow there is an error on a component the row concerned is put into an XML string and sent to a table in SQL. I am sure this could be done but have no idea how to do this dynamically for all the data in the row.

    The solution needs to be repeatable, with limited interaction when placed in the package. May be looking at building a custom task or putting it into BIML

    Cheers

    E

    😀

  • September 25, 2014 at 9:02 am

    #1748218

    I know I could pass out Flat File Source Error Output Column if the source of the Error was a flat file but it does not really point the finger at the incorrect column. I am looking for something a little better than this.

    Cheers

    E.

  • October 29, 2014 at 10:41 am

    #1755591

    Looks like this is what I was thinking of

    E

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

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