SSIS Error Code DTS_E_OLEDBERROR

• yuvipoy

  SSChampion

  Points: 10469

  More actions

  January 24, 2017 at 12:05 am

  #339616

  Loading multiple Excel sheet from folder

  getting error while changing the excel manager property in the "Expression" --> Excelfile path to @[User::InputFolder]
  click evaluate and click ok and set DelayValidation = True

  My excel source is getting below error , but if i did not choose this option it is looping 3 times same data without error as i am having three excel files

  Error at Package [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 JET Database Engine"
  Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot
  open the file ''. It is already opened exclusively by another user, or you
  need permission to view its data.".

  Error at Data Flow Task [Excel Destination [52]]: 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.

  how to resolve it , VS 2015 and database 2014

  Thanks in Advance.

• Thom A

  SSC Guru

  Points: 99133

  More actions

  January 24, 2017 at 2:11 am

  #1924539

  The error is showing that someone has the file open. Do you have it open in Excel, could someone else? Also, ensure the files aren't passworded.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk