SSIS: Issues running package with Excel Connection Manager error

Hi All,

I have a strange problem when running my SSIS package with an Excel Source and Excel connection manager.

Basically, the package imports an Excel file from a path on the C drive on the server. The package itself is running on the server too. Now when I connect to the server using Remote Desktop and copy the Excel file to the path on the server directly the package runs fine and imports the Excel file. However, when I map from my own desktop to the path on the server and copy the Excel file to the same path I get a
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
error.

When I right click on the Excel file that I copy via remote desktop and via mapped drive I notice under Properties > Security > Groups and User Names the one copied via Remote Desktop has my Windows Logon in it. However, the one via mapped drive does not have my Windows Logon in it.

I suspect this is the issue and is to do with permissions. I need anyone to be able to drop the Excel file via mapped drive for the SSIS package to import the Excel file.

Anyone, know how I can resolve this?

Thanks,

OS
onesegunAsked:
Who is Participating?
 
onesegunAuthor Commented:
Hi All and for the benefit of all,

After cracking my head for the whole day I figured that the problem was a permissions issue. When a user is copying from their computer onto the shared drive on the server the file is designated as read only and when that same user (me) tries to login to the server to run the SSIS package manually or via dtexec via windows task scheduler the Data Flow Task fails because the Excel file is read only due to the connection manager probably not being able to deal with a read only file.

Anyway, something for the sys admin to fix.

Thanks,

OS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.