I have an SSIS package that That contain an Execute Process Task Editor.
I've written a console app that formats and excel file.
I'm using the Executable: C:\Windows\System32\cmd.exe
Arguments: /c c:\application\file.exe 1 c:\filefolder\file.xls
the parameter 1 is a flag to tell it which path to take in the executable file.
I can run this in the IDE and when I deploy it I can run it in the Integration Services Catalogs using Excute, I set the runtime to use 32-bit runtime and it runs successfully.
When I create a job and do the same it fails.
The error in the ErrorDescription:
In Executing "C:\Windows\System32\cmd.exe" "/c c:\application\file.exe 1 c:\filefolder\file.xls" at "", The process exit code was "-532462766" while the expected was "0".
I created a batch file and the same thing happened I was able to run it in the IDE and in the Integration Services Catalogs using Execute,
I also tried to use the file.exe as an executable and it ran in the IDE and the Catalogs.
I tested it in the command window as well and it ran.
I'm at a loss does anyone have any ideas as to what I need to do to fix this. The DBA has said that the job has access and I am able to create the excel file on the server.
I'm running the version of SQL.
Microsoft SQL Server 2014 (SP2-CU17-GDR) (KB4505419) - 12.0.5659.1 (X64)
May 24 2019 19:09:40
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 17763: )
I did not set up the server nor did the DBA we inherited it.
Please help.
Thank you.