I am building a package that has 2 tasks that need to use the same excel connection manager. I use a execute sql task to dynamically build a table from the headers of the excel sheet ,then I use an excel source component to load the data from the sheet.
However when I try to edit the excel source and switch the data access mode to a variable and select the variable(for the path), when I try to close the editor I get this message
'S:\myfolder'. It is already opened exclusively by another user, or you need permission to view its data.
I need this package to access the same folder each time because the files will be placed in that folder.
This package also has a branch for loading a text file into sql server. It access the same folder but uses a flatfile connection manager
It looks like permissions on the folder are correct
View Complete Post