昨天朋友在64位环境开发SSIS的时候遇到一个问题：


The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

 

由于没有64位的Microsoft OLE DB Provider for Jet,所以在64位机器上使用SSIS调用Excel会遇到两个问题，一个是开发的时候遇到错误，另外一个是部署SSIS的时候遇到这个错误。

 

解决开发错误将Debugging属性“Run64BitRuntime”值改为False：

 

The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider i_The Excel Connection

 

The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider i_The Excel Connection_02

 

解决JOB部署错误，将执行选项使用32位运行时环境:

 

The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider i_The Excel Connection_03

问题解决，JOB运行成功：

The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider i_64bit_04

 

更多信息参考：在 64 位计算机上使用Integration Services 时的注意事项