Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting error in Lookup Transformation in SSIS


Getting error in Lookup Transformation in SSIS

Author
Message
satish.banda
satish.banda
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 161
Hi All,

Iam getting an error in Lookup transformation when iam truncating the lookup reference table. the package failed at the lookup if the reference table does not have the data.

if we load the data in reference table then the package is executing successfully.

can anybody help in this regard.

Thanks in advance
sathish
Michael Earl-395764
Michael Earl-395764
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3149 Visits: 23078
Perhaps I missed something in your post, but are you asking why a lookup fails if there is no data in the lookup table?

By default, if a value is not found during a lookup operation (your data flow has ID "1" but it is not in the lookup table) a lookup component will fail. You can configure the error output of the lookup to ignore failures. If you do this, not finding the record will result in returning NULL.
satish.banda
satish.banda
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 161
Thanks michel,

Actually, i would like to insert what are the rows the source table have and does not have the destination and also changed rows in the source table in to the destination by using conditional split transformation after the Lookup.

in this regard iam getting error.

any suggestions pls
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search