Lookup transformation

Comments (4)

kiran in Cincinnati, Ohio

88 months ago

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

Deepak in Cincinnati, Ohio

86 months ago

Put a filter for NULL after the lookup

Moin in Cleveland, Ohio

85 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

SQL Lion in Hyderabad, India

73 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/

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