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

  • Hi, Step 1 is to execute the SSIS Package (using 32-bit DTExec per your suggestion)

    "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /DTS "\MSDB\SSIS_Pkgs\ExcelModifer" /SERVER sqlreport /CHECKPOINTING OFF /REPORTING E

    The package contains the Powershell script that opens and modifies Excel.

    I have run the package from BIDS, and from Integrations Services with no problem.

    I have run the Powershell script by itself with no problem.

    However, when I run as a Package OR as a Powershell task in a SQL Job Step, I get the same result: Exception Error opening Excel.

    I am using a Proxy, I have checked all the permissions I can think of, I have run all the suggestions for DCOM modifications and for creating a Desktop file.

    At least this time it did something different, but I think it was a step backwards.

    Any ideas are greatly appreciated at this point, Thank you!