Post reply

Capture Transformation error

  • November 22, 2014 at 3:53 am

    #298835

    Hi to all,

    I have a data flow task with one source and one destination.

    Between source and destination I have a "derived column" transformation.

    I want capture a "derived column" executable error and write it in a Log table.

    For example, in the source i have a varchar field which values are integer and i want convert this values in integer before write them in the destinaton field.

    If one of the varchar strings has the following form: "1245c", the transformation from varchar to integer get error.

    How to capture a "derived column" executable error like in the above example?

    thanks in advance.

    P.S.: sorry, how to modify the topic title?

  • November 23, 2014 at 10:01 am

    #1760383

    any idea?

  • November 27, 2014 at 8:48 am

    #1761322

    please define capture.

    I have attached a simple screen shot. Basically put a flat file or OLEDB destination in the data flow , click on the derived column and drag it over to the destination. Then set it to pass the error to destination for Error or truncation. So when thee cast fails it goes down this route. You can also include a rowcounter on the way so the package knows how many rows have errored.

    Hope that helps.

    E

    And if you want something snazzier there are a few custom tasks about such as XMLify that take all of the columns passed to the task and slap it into one chunk of XML and then you have one generic error table.

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

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