Post reply

How Do I Address A Data Component In SSIS Script Task

  • 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

  • March 11, 2010 at 8:20 am

    #1132071

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

    Good luck.

    CEWII

  • March 12, 2010 at 10:09 am

    #1132846

    What add on would make this possible?

    Thanks,

    Kris

  • March 12, 2010 at 10:26 am

    #1132857

    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

  • March 12, 2010 at 1:17 pm

    #1132983

    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.

  • March 12, 2010 at 2:27 pm

    #1133016

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

    CEWII

  • March 12, 2010 at 2:39 pm

    #1133017

    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

  • March 12, 2010 at 2:57 pm

    #1133025

    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

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

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