November 4, 2008 at 2:57 am
Hi all,
I am developing a case study in ssis
I am having source with empty records(since records can be added later) and also my look up table is also having no records.
Now,i am mapping 2 columns in columns tab of loop up which is done by using "use sql query" instead of table .
and i am redirecting error row of look up to inserting into log file and green arrow to updating some other table..
but i am getting this error
Description: Row yielded no match during lookup.
Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "LOOK UP" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Output" " specifies failure on error. An error occurred on the specified object of the specified component.
Thanks in advance
April 29, 2009 at 11:22 pm
Hi, I am also facing the same issue in the lookup.
Error: 0xC020901E at ADRS-DFT, Lookup [9020]: Row yielded no match during lookup.
Error: 0xC0209029 at ADRS-DFT, Lookup [9020]: The "component "Lookup" (9020)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Output" (9022)" specifies failure on error. An error occurred on the specified object of the specified component.
I tried to redirect the failure rows but no help. It get failed in the lookup task.
Please let me know if you have any workaround to resolve this issue.
Thanks,
Balaji L
April 29, 2009 at 11:31 pm
Please confirm that you have tried changing the error row disposition to RD_RedirectRow? The error message strongly suggests not.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply