Solved

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

Posted on 2009-07-10
3
911 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.
0
Comment
Question by:amit_g
  • 2
3 Comments
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24852042
Could you attach the package example here to help you better?
regards,
Pedro
www.pedrocgd.blogspot.com
0
 
LVL 58

Author Comment

by:amit_g
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.
0
 
LVL 58

Accepted Solution

by:
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.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now