SSIS Execute Process Task fails with SQL agent

Question

I have a SSIS package with a Execute Process Task that runs an exe. All code and executables are located on the same server. The SSIS package runs inside the project but not when I upload to SSIS and run via SQL Server Agent. Unsure why it wont run in the Agent. Exe and package run fine by themselves but not in Agent. Appreciate any help. Below is the error I receive:

Microsoft (R) SQL Server Execute Package Utility Version 10.50.6000.34 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.

Started: 10:57:20 PM Error: 2018-10-19 10:57:43.83 Code: 0xC0029151 Source: Download XLS Execute Process Task
Description: In Executing "F:\Data Imports\Office_Codes_monthly_download\EXE\PullOffices.exe" "" at "F:\Data Imports\Office_Codes_monthly_download\EXE", The process exit code was "255" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:57:20 PM Finished: 10:57:43 PM Elapsed: 23.042 seconds

Is the executable in that location on the SQL Server? Does the user running the SQL Agent Job (most likely the service account) have access to the location and permissions to run the executable? — Jacob H
– Jacob H, Commented Oct 19, 2018 at 17:14
Maybe permissions? Does the account running agent or if using a proxy account have access to the exe? — Tim Mylott
– Tim Mylott, Commented Oct 19, 2018 at 17:14
yes the exe is in that location on the same server as the SQL server. I double checked the service account and it is an Admin with full permission to the folder and all contents. Not using a proxy. extra note....the exe will semi run. as in it will start to replace my file but not finish. so the file will have 0kb and wont open. but if i run the exe myself the file will fully be replace and openable. — the mad cat
– the mad cat, Commented Oct 19, 2018 at 17:32
its downloading an xls file from a website and saving it to a location on the server — the mad cat
– the mad cat, Commented Oct 19, 2018 at 17:51

Machavity · Accepted Answer · 2019-03-08 19:49:02Z

1

Try to pass the certificate information along with FTPES command like below.

open ftpes://FTPDDRIV:[email protected] -explicit -certificate=xx:71:xx:xx:a2:eb:23:xx:xx:eb:xx:x:xx:xx:5d:74:4d:c2:c6:37
put D:\UPSdata\UPSDrive\Integration\document.txt
exit

edited Mar 8, 2019 at 19:49

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

answered Mar 8, 2019 at 19:47

user11172803

111 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS Execute Process Task fails with SQL agent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related