Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Getting error in Lookup Transformation in SSIS Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2008 10:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 4, 2009 3:35 PM
Points: 25, 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
Post #485408
Posted Wednesday, April 16, 2008 6:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
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.
Post #485582
Posted Wednesday, April 16, 2008 6:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 4, 2009 3:35 PM
Points: 25, 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
Post #485596
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse