SQL 2008 SSIS to Excel 2007:  Cannot connect

Posted on 2012-09-10
Last Modified: 2012-09-10
Windows Server 2008 R2
SQL 2008
Excel 2007

I finally got a package created that would get past the 64 bit non support of Excel.  I had to use the wizard, but now the data set from my query is being written into my Excel spreadsheet perfectly.  I've tested it 3 or 4 times.  Good results every time.

Now, I create a job and call the SSIS package and start getting that error again:

Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is

What's going on?
Question by:DavidLumpkin
    LVL 13

    Accepted Solution

    Did you check the "Use 32-bit runtime" checkbox in the advanced configuration of your job?

    Author Comment

    I certainly appreciate the response.  I've looked every where and do not find a place to set this on the job.  I have googled for advance configuration for jobs and haven't found anything.  I'm sure I'm just missing it.

    Author Comment

    Found it!! Thank you, thank you.
    LVL 13

    Expert Comment

    Glad it helped...

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    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.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    730 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

    16 Experts available now in Live!

    Get 1:1 Help Now