Getting error in Lookup Transformation in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Getting error in Lookup Transformation in...

Getting error in Lookup Transformation in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

satish.banda

Posted Tuesday, April 15, 2008 10:29 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 04, 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

Michael Earl-395764

Posted Wednesday, April 16, 2008 6:11 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, 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

satish.banda

Posted Wednesday, April 16, 2008 6:24 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 04, 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 »

Permissions