Solved

SSIS: Issues running package with Excel Connection Manager error

Posted on 2013-11-14
1
507 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
0
Comment
Question by:onesegun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
onesegun earned 0 total points
ID: 39648512
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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question