Why can I run SSIS Fuzzy Grouping from Visual Stud

Question

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 by remoting to any of those servers, I get the PRODUCTLEVELTOLOW error when the Fuzzy Grouping component executes.

I'm running SQL Server 2005 Standard on all servers. I've read that SQL Server 2005 Enterprise is necessary to make use of Fuzzy Grouping and some other components. That fits with the error message, but if this is true why does it work from Visual Studio?

Thank you.

EDIT: Are there other methods out there to create a fuzzy grouping? Perhaps someone with experience with SSIS components could say whether creating a similar component would be an option?

Answer 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.