Post reply

Exporting to 32 Bit Excel in 64 Bit Enviroment

  • July 27, 2014 at 9:33 pm

    #397125

    Hi All,

    I have recently upgraded from SQL Server 2005 to SQL Server 2008 R2 running on Windows Server 2008 R2 64 bit OS.

    I have over 100 SQL jobs from SQL 2005 and i am setting them up in the new environment. They all select rows from the SQL tables and dump them in excel files which are then FTP to another server.

    My question is, once i selected the 32 bit switch in the jobs and in the SSIS projects they all run fine and the data is exported correctly. But I get an error when I select the preview button on the excel destination, error "There was an error displaying the preview".

    Now from what I have read this is due to 32 bit excel in 64 bit server environment. Also due to the constraints of the destination application, the files they have to be kept as .xls 2003 worksheet.

    Is there a way to view the .xls excel data in BIDS 2008(64 bit server)?

    Thanks

  • July 27, 2014 at 10:11 pm

    #1732694

    Finally found the answer.

    Launching the install of a Microsoft ACE OLEDB Provider on a machine with an Office install other than the current one (e.g. 32 on 64) will cause the install to fail. To have it run properly you need to launch it from a command line with the “/passive” argument specified.

    To install the Microsoft ACE OLEDB Provider 32-bit on a machine running Office 2010 64-bit:

    $> AccessDatabaseEngine.exe /passive

    To install the Microsoft ACE OLEDB Provider 64-bit on a machine running Office 2010 32-bit:

    $> AccessDatabaseEngine_X64.exe /passive

    Thanks Carl from his blog.

    http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/

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

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