Lookup transformation

Get new comments by email
You can cancel email alerts at anytime.
Comments (4)

kiran in Cincinnati, Ohio

81 months ago

How to reject records which are not found in the lookup table?
Currently it is inserting NULL values

- Was this comment helpful? Yes (13) / No (1) Reply - Report abuse

Deepak in Cincinnati, Ohio

79 months ago

Put a filter for NULL after the lookup

- Was this comment helpful? Yes (2) / No Reply - Report abuse

Moin in Cleveland, Ohio

78 months ago

kiran in Cincinnati, Ohio said: How to reject records which are not found in the lookup table?
Currently it is inserting NULL values

Hi,

Place filter transformation after lookup set it true and use update strategy with DD_REJECT.

Thanks

- Was this comment helpful? Yes / No Reply - Report abuse

SQL Lion in Hyderabad, India

66 months ago

Thank you for the valuable information of Lookup transformation. You will get more information regarding the API and programming stuffs for Lookup transformation for SSIS in the below link.
www.sqllion.com/2009/05/programming-lookup-transformation/

- Was this comment helpful? Yes / No (1) Reply - Report abuse

» Sign in or create an account to comment on this topic.