How can i Dynamically set a property in fuzzylookUp dataflow task + ssis?

• melisathomas_s

  SSC Rookie

  Points: 43

  More actions

  May 12, 2008 at 4:37 am

  #121544

  Hi

  I am working on a SSIS Package with FuzzyLook up as my dataflow task.I need to dynamically set the MaxOutputMatchPerInput property of the FuzzyLookUp dataflow task.And the value would be select count(*) from table1".Number of Records in this table changes during runtime.

  1) If i am setting this count in a variable how can i access it in my FuzzyLookUp component? How can i set this MaxOutputMatchPerInput property?

  2) I want my input record to match with all the records of the reference table.How can i do this otherwise?

  Thanks

  Jesica

• Bindu-330959

  Old Hand

  Points: 362

  More actions

  May 14, 2008 at 6:24 am

  #815098

  Hi

  Can you please post more details about the requirement so that i can give a try

  Regards

  Bindu