Solved

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

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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 video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

828 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