CODEWITHSUNDEEP
sql-serverexcelssisetlssis-2012
MJ8
MJ8

Reputation: 305

SSIS Excel File issue - Failure creating file

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

i also have installed 64 bit access driver engin . That did not help either.

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.".

Upvotes: 3

Views: 11566

Answers (3)

Nolan Shang
Nolan Shang

Reputation: 2328

I had the same error too, my files are save in a folder OneDrive. I fix the error by moving the files out from Onerive

Upvotes: 0

arvind tegampure
arvind tegampure

Reputation: 33

I had the same error, to fix it I specified the IP of the shared folder instead of FQDN.

Upvotes: 1

Hadi
Hadi

Reputation: 37313

Failure creating file

This error is thrown when the Excel connection manager cannot access to the chosen path, it might be caused by:

  • You are using a network path / try replacing with a local path
  • it might be pointed to your local server, but when it is deployed to another server it will throw error
  • you do not have permission to access the selected path from the account that is running the SSIS
  • path does not exists

Upvotes: 2

Related Questions