September 19, 2008 at 12:27 pm
Hi,
I'm having this problem. I'm using look up task in my ssis packages, but when i'm passing the output from 1st look up task to the second look up task only thru error output, i'm losing the data. This is the warning i receive.
"Rows sent to the error output(s) will be lost. Add new data flow transformations or destinations to receive error rows, or reconfigure the component to stop redirecting rows to the error output(s)."
My question is if i use look up error output only, in the transformation flow, is the data lost?
pleas advice
September 19, 2008 at 11:08 pm
Did you check for Lookup Configure Error Output option is set to Redirect Row? Set all columns to Redirect Row on error.
September 22, 2008 at 9:06 am
Yes, the error outout is configured as Redirect row, but still i get the warning and i dont see the data.
June 12, 2009 at 5:28 am
I have exactly the same issue - a lookup with columns I want to pass to an OLEDB command task on error. If I set this up to flow on success I can see my new columns in the available columns list, but not if I set the flow to error.
I have set task to redirect row in the lookup.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply