SSIS Multiple File Load Error with Variable

1

I have an SSIS package that is to load multiple Excel files using the For Each Loop Containter. As soon as I add the variable in the Excel Connection manager in expressions, under ExcelFilePath Property it throws an error in the Excel Source Package:

An OLEDB error has occurred 0X80004005. The MIcrosoft Access Database Engine cannot write to the file "C:..."

It is already opened exclusively by another user or you need permission. I had to already download the 32bit Extension to be able to view the Excel files. I've followed many guides on how to do this, and it always ends up in the same result. Delay validations are set to True. Any idea how to fix?

sql-server
excel
visual-studio
ssis
oledb
asked on Stack Overflow May 13, 2019 by Ginger22 • edited May 13, 2019 by Hadi

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0