SSIS Excel文件问题-创建文件失败 [英] SSIS Excel File issue - Failure creating file
问题描述
我有SSIS包，可抓取excel文件并将其加载到sql表.运行它时出现以下错误.我试图使运行在64位上为false.没用
I have SSIS package that grabs excel file and load it to sql table .i get the following error when i run it. I have tried to make run on 64 bit to false. That did not work
我还安装了64位访问驱动程序engin.那也没有帮助.
i also have installed 64 bit access driver engin . That did not help either.
数据流任务[Excel来源[2]]中的错误:SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.对连接管理器"Excel Connection Manager"的AcquireConnection方法调用失败，错误代码为0xC0202009.在此之前可能会发布错误消息，并详细说明为什么AcquireConnection方法调用失败的原因.
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.
数据流任务[SSIS.Pipeline]发生错误:Excel Source验证失败，并返回了错误代码0xC020801C.
Error at Data Flow Task [SSIS.Pipeline]: Excel Source failed validation and returned error code 0xC020801C.
数据流任务[SSIS.Pipeline]出错:一个或多个组件验证失败.
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
数据流任务出错:任务验证过程中发生了错误.
Error at Data Flow Task: There were errors during task validation.
ABC上的错误[连接管理器"Excel连接管理器"]:SSIS错误代码DTS_E_OLEDBERROR.发生OLE DB错误.错误代码:0x80004005. OLE DB记录可用.来源:"Microsoft Access数据库引擎"结果:0x80004005说明:创建文件失败.".
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.".
推荐答案
创建文件失败
Failure creating file
当Excel连接管理器无法访问所选路径时，抛出此错误，可能是由以下原因引起的:
This error is thrown when the Excel connection manager cannot access to the chosen path, it might be caused by:
- 您正在使用网络路径/尝试用本地路径替换
- 它可能指向您的本地服务器，但是当它部署到另一台服务器时，它将引发错误
- 您无权从运行SSIS的帐户访问所选路径
- 路径不存在
这篇关于SSIS Excel文件问题-创建文件失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
