We help IT Professionals succeed at work.
Get Started

SSIS: Issues running package with Excel Connection Manager error

812 Views
Last Modified: 2016-02-11
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
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE