We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Update reference table in SSIS 2005 fuzzy lookup at runtime based on a variable

amit_g
amit_g asked
on
Medium Priority
964 Views
Last Modified: 2013-11-10
Can the reference table be updated based on some variable at runtime? In one of the SSIS I want a variable to determine what table to use as a reference table in the Fuzzy lookup. I was hoping to write multiple views and use those as reference table based on the value of a variable but I could not find a way to change the reference table name at runtime. Ideally, I would like to use the same table and have a filter (where ColX = Variable) but multiple views would be acceptable too.

I am using SQL Server 2005.
Comment
Watch Question

Commented:
Could you attach the package example here to help you better?
regards,
Pedro
www.pedrocgd.blogspot.com
CERTIFIED EXPERT
Top Expert 2006

Author

Commented:
I would have to trim it down quite a bit as the problem area is just a small piece. However, the problem is very generic. In the Fuzzy Logic data step we need to pick a table/view as a reference table. This table is to be picked at design stage. I am trying to find a way to change it at runtime based on some variable.
CERTIFIED EXPERT
Top Expert 2006
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*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.