How Do I Address A Data Component In SSIS Script Task

Question

Post reply

How Do I Address A Data Component In SSIS Script Task

msflinxusa

SSC Rookie

Points: 42
More actions
March 11, 2010 at 7:44 am

#139316

Ok -- Experts Exchange has let me down, I need help.
Go to this weblink to see the original question:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_25300239.html
I am writing a SQL Task in the Control section of the SSIS Package. I am trying to get to the Fuzzy Transformation component of a Data Flow Task in my package. I don't know how to "address" the component, nor it's variables.
Anyone know how to do this?
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Using out of the box components you can't. Sorry.

Good luck.

CEWII

msflinxusa SSC Rookie Points: 42 More actions · Answer 2

msflinxusa

SSC Rookie

Points: 42

March 12, 2010 at 10:09 am

#1132846

What add on would make this possible?

Thanks,

Kris

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

I should have asked this earlier.

Instead of telling us how you want to solve the problem why don't you tell us what problem you are trying to solve.

CEWII

msflinxusa SSC Rookie Points: 42 More actions · Answer 4

I am creating an SSIS package to remove duplicates from (currently) the persons table.

We have approx. 50 clients, each wanting to set their own paramenters for what they consider a viable match. So, example

Overall match: 60% Manual Review

Field Match (The following MUST add up to 100%)

Prefix: 2%

First Name: 20%

Middle Name 3%

Last Name 40%

Suffix 10%

SSN 15%

DOB 10%

Driver's License 0%

Mother's Maiden Name 0%

So, the field variables would be set as minimum similarity in the column relationships.

The manual review would be in the Transformation Editor Similarity threshold.

Since these values will be set by each client, I am planning to place them in a table, call them into the SSIS package and set them into Global Variables. Then, I want to be able to set the similarity threshold values, programatically, using those Global Variables.

Make sense? Any questions, please post and I will try to answer.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

I have another question, are you going to be using Enterprise Edition? If not Fuzzy Lookup isn't available.

CEWII

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

I just finished looking and there are effectively no options that can be set at run-time for the Fuzzy Lookup. Everything is set at design-time.

So I don't see a way to do this the way you want.. I looked for a 3rd party replacement for the Fuzzy Lookup and was unable to find one.

Sorry.

CEWII

msflinxusa SSC Rookie Points: 42 More actions · Answer 7

Elliott W (3/12/2010)
I have another question, are you going to be using Enterprise Edition? If not Fuzzy Lookup isn't available.

Yes

Elliott W (3/12/2010)
I just finished looking and there are effectively no options that can be set at run-time for the Fuzzy Lookup. Everything is set at design-time.
So I don't see a way to do this the way you want.. I looked for a 3rd party replacement for the Fuzzy Lookup and was unable to find one.

:crying: :crying: :crying: :crying: :crying: :crying:

Oh well.... Thanks anyhow