Home Forums Programming Powershell Open Excel Error Using PowerShell in SQL Server Agent Job RE: Open Excel Error Using PowerShell in SQL Server Agent Job

  • I know that you need to run SSIS in 32-bit mode if you are using Excel to ensure that the ODBC (Jet) engine it uses (which is 32-bit) runs correctly. Have you tried running the 32-bit version of DTExec?

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!