Dynamic SSIS Package for Fuzzy Grouping

1
votes

I have created SSIS Package for Fuzzy Grouping.

I just want to execute package using .config file, which should contain the connection property and inputs for Fuzzy Grouping as I have to run the package for many times for different table and column name.

enter image description here

Question : Is there any solution for creating dynamic ssis package for fuzzy grouping?

1
ssis
Depending on the type of matches you're attempting to do and the volumes of data (source vs reference), you might be able to roll your own and get a dynamic matcher thing working as you desire but that'll take some programming work. – billinkc

1 Answers

2
votes

I don't think this (dynamic fuzzy lookup) is going to work. Behind the scenes, the Fuzzy Lookup is going to be creating tables of reference data aka Error-Tolerant Index (ETI) and since each one of your source tables would be unique, you wouldn't be able to cycle through them like you're hoping to do.

I usually suggest a Biml approach (generate all possible packages) but I wonder if the ETI step of the SSIS package creation process is something like the OLE DB Destination Table where you can create the target table. It's a feature in the designer but you can't systematically create the target table. i.e. the object model doesn't have CreateTargetTable method associated to the OLE DB Destination. It's just some jiggery pokery that the VS designer allows.

Caveat

I have not tested this but I'm willing to risk my unicorn points