为什么我可以从 Visual Studio 运行 SSIS Fuzzy Grouping 而不能从部署的包运行? [英] Why can I run SSIS Fuzzy Grouping from Visual Studio but not the deployed package?

问题描述

我编写了一个 SSIS 包来创建模糊分组.我可以从针对我的任何服务器的 Visual Studio 运行它，并且它可以毫无问题地运行.如果我尝试通过远程连接到这些服务器中的任何一个来运行 dtsx，则在执行模糊分组组件时，我会收到 PRODUCTLEVELTOLOW 错误.

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.

我在所有服务器上运行 SQL Server 2005 Standard.我读到 SQL Server 2005 Enterprise 是使用模糊分组和其他一些组件所必需的.这符合错误消息，但如果这是真的，为什么它可以在 Visual Studio 中工作?

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?

谢谢.

还有其他方法可以创建模糊分组吗?也许有 SSIS 组件经验的人可以说是否可以选择创建类似的组件?

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?

推荐答案

如您所见，模糊分组转换是企业版(或更高版本)的一项功能.

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

企业级功能可用的原因是 MS 公开了 Visual Studio 基本上使用的开发人员版的全套选项.

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.

如果@Aaron Bertrand 在此线程中插话，我认为他有一个连接问题，要求 VS 允许您针对目标版本进行开发，这样人们就不会陷入为标准版功能集开发企业版级别的解决方案.

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.

这篇关于为什么我可以从 Visual Studio 运行 SSIS Fuzzy Grouping 而不能从部署的包运行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！