Hi all, I'd like to be able to set the MinSimilarity property of the FuzzyGrouping data flow component dynamically, but SSIS doesn't seem to let me do this either via using a variable expression or through a package configuration. Can anyone suggest another way to do this? It seems for example you can use a script task to programatically set data flow component properties, but I can't find any examples. Thanks, Matt

There isn't any way to do this beyond using the SSIS API to modify the package contents before you run it. To dispel some myths first off: You can (sometimes) make properties of data flow transformations dynamic by using expressions. You'd do so by selecting the data flow background, or the data flow task itself while in control flow view, and looking at the properties (F4). In the case of fuzzy grouping, it only exposes the max memory property to expressions, not the similarity property. You can not use any tool inside a package to dynamically modify the structure of the package. This includes the script task. You can't use the script task to modify properties on other tasks or components in your package (beyond modifying variables that are used in property expressions). Any documentation or samples you see doing this aren't modifying the executing package... they're modifying (if anything) the "on disk" copy of the package, not the "in memory" executing copy. You can use the API, through another package's script task, or any .Net platform (C# app, etc...) to programatically modify an SSIS package. Once modified, you can then initiate execution of the package. Talk to me now on

Todd, Thanks for your reply and assistance. Do you have any samples or links you could share of how to modify an external package from a script task? Kind regards, Matt

Doesn't really matter if you use a Script Task or just a C# console app. MSDN has a bunch of stuff, and ssisbi.com does too - but it's buried because his tags don't work. Talk to me now on