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

Posted on 2009-07-10
Medium Priority
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.
Question by:amit_g
  • 2
LVL 22

Expert Comment

ID: 24852042
Could you attach the package example here to help you better?
LVL 58

Author Comment

ID: 24856524
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.
LVL 58

Accepted Solution

amit_g earned 0 total points
ID: 24881380
We ended up using one of the reference table column as "Exact Match". That changes the similarity and Confidence but we could deal with that. I could not find a way to change the reference table name at runtime.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question