SSIS Excel File issue - Failure creating file

2

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

sql-server
excel
ssis
etl
ssis-2012
asked on Stack Overflow Nov 9, 2017 by MJ8 • edited Nov 12, 2017 by Hadi

2 Answers

2

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
answered on Stack Overflow Nov 9, 2017 by Hadi
0

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

answered on Stack Overflow Nov 18, 2020 by arvind tegampure

User contributions licensed under CC BY-SA 3.0