Post reply

SSIS - excel connection manager failing due to 64 bit

  • September 12, 2014 at 11:43 am

    #290718

    The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

    YES, I've already checked the 'run in 32 bit mode' in SQL job agent.

    My BIDS is in 2008, my SQL server that hosts the sql job agent is 10.0.5512, the OLE DB connection is going to a 2012 sql server.

    Trying to output to excel 2007, any ideas. Trying to avoid using a script task to just custom code the whole thing, then kinda defeats the purpose of claiming the ssis package is 'superior' in reliability to my old custom vb code.

  • September 12, 2014 at 12:16 pm

    #1745171

    You might need to change the project properties in SSIS. In the project drop down, click project properties at the bottom. Under Configuration Properties click on Debugging. Change the Run64BitRuntime to False.

    Not sure if this will solve your problem, but it helped me out when I was having trouble with an Excel connection before.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply