excel - 将 ssis 包中的数据导出到 Excel 目标时出错

Question

我刚刚将 ssis 包从桌面移动到服务器。该包将数据从 sqlserver 导出到 Excel 工作表。当我尝试运行该包时，我看到以下错误。错误发生在数据流任务的 Excel 目标中。

Error at Package [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000.
An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

Error at Data Flow Task [Excel Destination [16]]: SSIS Error Code 


[Excel Destination [16]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The   AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC020  9302.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

我还进行了以下更改，因为我之前遇到了错误，并且该包甚至无法运行。

将数据流任务的延迟验证设置为 false。将项目属性下的Run64bitruntime设置为true

谁能告诉我我需要做什么？

PS:我在服务器上运行该软件包，但未安装 MS excel。这会导致错误吗？

Answer 1

PS : I am running the package on the server and MS excel is not installed on it . Could that be causing the error ?

是的

我还找到了另一个描述解决方案的线程:

HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

这不涉及安装完整版本的 Office:

NOTE: this DOES work for office 2010 even though it is for 2007 office, dont ask me why it just does :)

1. download and install this: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

2. in VS click add data source, follow the wizard and enjoy! :)

他们正在使用 Visual Studio，但我想您应该能够运行 SSIS 包，而无需“添加数据源”，因为它正在寻找 COM 组件microsoft.ace.oledb.12.0现在应该已注册。