Why Can I Run Ssis Fuzzy Grouping From Visual Studio But Not The Deployed Package?

I have written an SSIS package to create a Fuzzy Grouping. I can run it from Visual Studio targeting any of my servers and it will run without any problem. If I try to run the dtsx

Solution 1:

As you have correctly identified, Fuzzy Grouping transformation is an Enterprise Edition (or greater) feature.

The reason for Enterprise level features being available is that MS exposes the full set of options for the developer edition which is what Visual Studio is basically using.

If @Aaron Bertrand chimes in on this thread, I think he has a connect issue requesting that VS allows you to develop against the target edition so people don't get stuck developing Enterprise Edition level solutions for Standard edition feature set.