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!