Solved

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

Posted on 2009-07-10
3
910 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.

Join & Write a Comment

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

758 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