Is refreshing Excel from SSIS without office installed no longer possible?

• d_george

  SSCrazy

  Points: 2462

  More actions

  March 3, 2016 at 6:04 am

  #311861

  Based on a 2008 post: http://jessicammoss.blogspot.com/2008/10/manipulating-excel-spreadsheets-in-ssis.html all that should need to be done is "ensure that Microsoft.Office.Interop.Excel is registered in the GAC."

  However, a 2012 post http://stackoverflow.com/questions/11448197/how-to-use-microsoft-office-interop-excel-on-a-machine-without-installed-ms-offi states this is not possible.

  Back to debugging the 2008 post... This code works fine a dev machine (of course with office) but does not work on the SSIS box. (Error: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).)

  *note - SSIS is Windows Server 2008 R2 and has AccessDatabaseEngine_x64.exe and PrimaryInteropAssembly.exe installed.

  The script task has been given a direct reference to the file and that structure and permissions have been carried over to the SSIS box.

  The fail happens in 32 and 64 modes (32 PIA isn’t installed anyway).

  I cannot find Excel in Component services>Computers>My Computer>DCOM Config to give advanced permissions/investigate (because office isn’t installed probably).

  Microsoft.Office.Interop.Excel.dll is in the GAC and also every Bin(n) and Net framework folder available which is the DLL used/referenced in the script task.

  My first question is – is this no longer possible?

  If it is possible, please point me in the right direction.

  Thank you