SSIS包问题与Excel连接管理器。

In my local machine, SQL job runs perfectly. Inside SQL job there is SSIS package which grab Excel data and load into the Staging table. There is Microsoft Excel 2010 in my System.

在我的本地机器中，SQL作业运行得很好。在SQL作业内部有一个SSIS包，它获取Excel数据并将其加载到Staging表中。我的系统中有Microsoft Excel 2010。

Now the issue is on Development Server. Same job with same SSIS package which in Network folder run with issue. The Development server consist a Excel 2013

现在问题出现在开发服务器上。在网络文件夹中运行的相同的SSIS包的工作。开发服务器包括一个Excel 2013

I don have enough reputation to show the screenshot of the error message. Here is the error saying.

我没有足够的声誉来显示错误消息的屏幕截图。这是错误的说法。

Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. 
Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft Office Access Database Engine"  
Hresult: 0x80004005  Description: "External table is not in the expected format.".  
End Error  Error: 2015-07-10 14:16:05.52     
Code: 0xC020801C     
Source: Data Flow Task Excel Source [2]     
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed. 

Error: 2015-07-10 14:16:05.52     
Code: 0xC0047017     
Source: Data Flow Task SSIS.Pipeline     
Description: Excel Source failed validation and returned error code 0xC020801C.  

Error: 2015-07-10 14:16:05.52     
Code: 0xC004700C     
Source: Data Flow Task SSIS.Pipeline     
Description: One or more component failed validation

1 个解决方案

#1

also, two things 1) make sure your excel file is NOT open 2) ssis cant use excel in 64bit mode, change your deployment settings to use 32 bit runtime (if youre using an sql job, check the settings)

还有两点:1)确保您的excel文件没有打开2)ssis不能在64位模式下使用excel，更改部署设置以使用32位运行时(如果您正在使用sql作业，请检查设置)