Post reply

Redirecting the error row to a flat file from oledb destination

  • July 5, 2011 at 1:22 am

    #389893

    HI All,

    How can we redirect an error row from oledb destination to a flat file?

    Can anyone help me in this regard.

    Thanks,

    Sreelekha

  • July 5, 2011 at 1:49 am

    #1348091

    Basically, you change the row disposition on your oledb destination to send error rows to an error output rather than fail and divert that path to a flat file component.

    -> Right click your destination

    -> Edit

    -> Error Output tab

    -> Change error value to redirect row

    -> OK, back to data flow

    -> add your flat file destination

    -> connect your new output from the oledb dest to your flat file dest

    -> configure as you like

    HTH

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

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