Solved

SSIS: Issues running package with Excel Connection Manager error

Posted on 2013-11-14
1
492 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
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
certification for SQL 2016 10 61
Record extraction 3 14
Row-Level Security 2 19
SQL query to summarize items per month 5 27
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now