Monday, February 13, 2012

access inserted data

i have a oledb destination in my data flow pointing to table ABC and an

error output if the insert failed..follow the error output, i have a

lookup on table ABC which doesn't seem to work..is it possible to

access new data in table ABC follow the error output?

thanks

Thanh Duong wrote:

i have a oledb destination in my data flow pointing to table ABC and an error output if the insert failed..follow the error output, i have a lookup on table ABC which doesn't seem to work..is it possible to access new data in table ABC follow the error output?

thanks

No.

Push the error rows into a raw file and then do your lookup in another data flow task.

-Jamie

No comments:

Post a Comment