We help IT Professionals succeed at work.

How to validate lookup transformations conditionally?

dorsun
dorsun asked
on
Medium Priority
513 Views
Last Modified: 2013-11-10
In my source file, I have a lookup field that needs to be validated against the ID of the lookup table in the database.
The source lookup field may contain nulls since the destination table field has nullable property set.
1. How do I validate my source lookup field for only the not null data?
2. If the source look up field value does not match with the data in the database lookup table, how do I assign a default value to the source lookup field?

Please suggest.

Thanks.
Comment
Watch Question

Commented:
Follow the pipeline in the attached image.
Helped?
regards,
Pedro
www.pedrocgd.blogspot.com
SSIS-Lookup-Redirect.JPG

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks Pedro,

I will follow the way you suggest.
Can yo uplease let me know how would the flow look like if I have more than one lookup fields to validate from the source file?

Thanks,
Dorothy
Commented:
After the union all add other lookup and do the same to redirect the rows.
Also take a look to a post in my blog:
http://pedrocgd.blogspot.com/2008/04/dear-friends-today-i-will-describe.html
Helped?
regards,
pedro

Author

Commented:
My requirement is :
I need to validate the lookup field.
If the lookup value is not valid, I need to log it in an error table and make the source field value to null.
Also I need to output all the records (even the recors with null lookup value)
Can you please help me out in this process?

Author

Commented:
Thank you
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.