sql-server - SSIS Excel 文件问题 - 创建文件失败

Question

我有 SSIS 包，可以抓取 excel 文件并将其加载到 sql 表。我在运行它时收到以下错误。我试图将 run on 64 bit 设置为 false。那没有用

我还安装了 64 位访问驱动程序 engin。这也没有帮助。

Error at Data Flow Task [Excel Source [2]]: 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 at Data Flow Task [SSIS.Pipeline]: Excel Source failed validation and returned error code 0xC020801C.

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

Error at ABC [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "Failure creating file.".

Answer 1

Failure creating file

当 Excel 连接管理器无法访问所选路径时抛出此错误，可能是由于:

• 您正在使用网络路径/尝试用本地路径替换
• 它可能指向您的本地服务器，但是当它部署到另一台服务器时会抛出错误
• 您无权从运行 SSIS 的帐户访问所选路径
• 路径不存在