我已经使用Visual Studio 2015创建了一个SSIS包,该包将一个Excel文件导入到数据库中。这项工作已经顺利进行了数周,但由于某种原因,今天上午失败了。当我将其作为自己的程序包运行时,它可以完美运行,但是只要它在工作中,即使这是工作的唯一步骤,它都会失败。它正在使用32位运行时运行。我收到的错误粘贴在下面。
Executed as user: NA\SQL_INTDB01$. Microsoft (R) SQL Server Execute Package
Utility Version 13.0.1601.5 for 32-bit Copyright (C) 2016 Microsoft. All
rights reserved. Started: 9:41:48 AM Error: 2018-01-04 09:41:49.36
Code: 0xC0202009 Source: STRATImport Connection manager "Excel
Connection Manager" Description: 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.". End Error Error: 2018-01-04
09:41:49.36 Code: 0xC020801C Source: Data Flow Task 1 Excel Source
[71] 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. End Error
Error: 2018-01-04 09:41:49.36 Code: 0xC0047017 Source: Data Flow
Task 1 SSIS.Pipeline Description: Excel Source failed validation and
returned error code 0xC020801C. End Error Error: 2018-01-04 09:41:49.36
Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description:
One or more component failed validation. End Error Error: 2018-01-04
09:41:49.36 Code: 0xC0024107 Source: Data Flow Task 1
Description: There were errors during task validation. End Error DTExec:
The package execution returned DTSER_FAILURE (1). Started: 9:41:48 AM
Finished: 9:41:49 AM Elapsed: 0.438 seconds. The package execution
failed. The step failed.
最佳答案
Microsoft Access数据库引擎已引发以下错误:
创建文件失败
当Excel连接管理器无法访问所选路径时,将引发此错误,可能是由于:
您正在使用网络路径/尝试用本地路径替换
它可能指向您的本地服务器,但是当它部署到另一台服务器时,它将引发错误
您没有权限从运行SSIS的帐户访问所选路径
路径不存在
参考资料
SSIS Excel File issue - Failure creating file
Failure creating file" error trying to drop and create tables in an Excel data source