I am trying to deliver an SSIS package to SQL Server 2005 Enterprise Edition running on Windows Server 2003 R2 (64bit).
我正在尝试将SSIS包提供给在Windows Server 2003 R2(64位)上运行的SQL Server 2005 Enterprise Edition。
The package itself is quite simple, just a basic read/write of a MySQL table (testing the integration).
包本身非常简单,只是MySQL表的基本读/写(测试集成)。
I am able to build and deploy the package on my development machine, and I'm able to debug & build the package on the server that will eventually host it (using the local install of BIDS), but for some reason the deployment wizard fails when I attempt to execute the build package from Windows.
我能够在我的开发机器上构建和部署软件包,并且我能够在最终托管它的服务器上调试和构建软件包(使用本地安装的BIDS),但由于某种原因,部署向导失败了当我尝试从Windows执行构建包时。
The error message that I get is:
我得到的错误消息是:
TITLE: Package Installation Wizard
------------------------------
Unexpected error occurred.
------------------------------
ADDITIONAL INFORMATION:
Retrieving the COM class factory for component with
CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due
to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
------------------------------
Retrieving the COM class factory for component with
CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due
to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
The install seems to have the DLLs in the right place... Has anybody else come across this particular problem? Any tips would be appreciated. I've looked up the error in various places, but cant' seem to find any other cases quite the same as mine.
安装似乎有DLL在正确的位置......有没有其他人遇到这个特殊的问题?任何提示将不胜感激。我在各个地方都查了一下这个错误,但似乎找不到其他任何与我相同的情况。
Many thanks, Stuart
非常感谢,斯图尔特
1 个解决方案
#1
Upgrading the install to SQL Server 2005 SP2 solved this issue.
将安装升级到SQL Server 2005 SP2解决了此问题。
#1
Upgrading the install to SQL Server 2005 SP2 solved this issue.
将安装升级到SQL Server 2005 SP2解决了此问题。