CODEWITHSUNDEEP
sql-serverssissql-server-job
the mad cat
the mad cat

Reputation: 3

SSIS Execute Process Task fails with SQL agent

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

Upvotes: 0

Views: 1567

Answers (1)

user11172803
user11172803

Reputation: 11

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

Upvotes: 1

Related Questions