Excel connection manager Error while running a package on a server

Posted on 2011-10-03
Last Modified: 2012-05-12
Hi experts, I have a problem where my package runs on my local drive but when I put it on a server where excel is not installed, it throws an error, not sure what the workaround is, the package here that I have creates an excel file with a tab and headers and later dataflow task to export data to excel. I have had packages created on the same server where I had data imported from excel files but I dont understand why we cant do it the other way....
Appreciate your help...

ERROR MESSAGE[Execute SQL Task] Error: Failed to acquire connection "Excel Connection Manager". Connection may not be configured correctly or you may not have the right permissions on this connection.
Question by:sqlcurious
    LVL 3

    Accepted Solution

    I can think of two possible causes:

    1) the user running the package does not have sufficient access rights on the Excel file.

    2) You are running the package in 64 bit mode on the server. The OLEDB provider to connect to Excel files is not available in 64 bit.
    Check the "Running integration services packages on 64 bit computers" section in following link for more information about running packages in 32/64 bit mode:


    Author Comment

    Hi Bartvx, its not the case 1 and regarding the option 2- I have already turned off the 62 bit option. There is something else that's happening
    LVL 3

    Assisted Solution

    Are you trying to connect to Excel 2007? If so, install the Office 2007 Data Connectivity Components from
     on the server.

    If this is not the case, let's make sure the 64 bit issue is not the problem:

    If you mean the Run64BitRuntime  option in the debugger options: Thi option only applies at design time and will have no effect when you execute the package on the server.

    If you launch 'dtexec' command  in a command prompt without parameters on the server, what can you see in the version section?

    If it says 64 bit, try to locate the 32 bit version of dtexec (typically in C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn. (note the X86 part) Then try to execute the package explicitly specifying the path to the 32 bit version.

    ex: "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec" /f c:\mypackage.dtsx

    Some more questions to make finding the solution easier:
    What version of SQL are we talking about?
    What are the versions of dtexec on your local PC and on the server?
    What provider do you use to connect to Excel?
    LVL 3

    Expert Comment

    Addendum: for Excel 2010 the installation of Microsoft Access Database Engine is required, you can download it here:


    Author Comment

    I am not allowed to install any office products so the solutions above wouldnt work, please provide me alternative solutions.
    Hi Bartvx answers to ur questions:
    What version of SQL are we talking about?  - SQL server 2008 R2
    What are the versions of dtexec on your local PC and on the server? both are the same
    What provider do you use to connect to Excel? - excel connection manager

    LVL 3

    Expert Comment

    As far as I know there is no way to connect without those drivers installed. :(

    The only other option that I see is that you run the package on another computer (with connection to the database on the target server) where you are allowed to install the Office drivers.

    Note that the links I posted are not the actual Office products, but merely the office connectivity tools which are free to download.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>I am not allowed to install any office products<<
    Thank goodness for that.  Suggesting you install MS Office on a Production SQL Server is dangerous at best.

    Author Comment

    k got it, I got confused, will try the above options and let you know if I come across any hiccups, thanks Bartvx!

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    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…
    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.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

    758 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

    7 Experts available now in Live!

    Get 1:1 Help Now