We have an issue sending large files > 100 kb using sftp connection through ssis - where the transfer fails & files deployed at sftp have ".filepart" extension added to it.
The commands used are passed as an argument file to ssis - execute process task to open Winscript bat file.
The commands are as below -
The error we are getting is as below hen we run the ssis through sql server agent -
Cannot overwrite remote file '\..\testdirname\filename.txt.filepart'. Press 'Delete' to delete the file and create new one instead of overwriting it. No such file or directory. Error code: 2 Error message from server (en): File not found (D)elete, (A)bort, (R)etry, (S)kip, Ski(p) all: Abort Microsoft (R) SQL Server Execute Package Utility Version 12.0.4100.1 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 4:06:48 PM Error: 2020-04-15 16:09:58.60 Code: 0xC0029151 Source: dynamic - Execute Process Task Execute Process Task Description: In Executing "\\dirname\OpenWinscp.bat" "test.txt" at "Winscriptdirname\WinScripts", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:06:48 PM Finished: 4:09:58 PM Elapsed: 190.297 seconds. The package execution failed. The step failed.
I am successfully able to suppress "filepart" through command line using the above mentioned commands & the transfer is successful.
It's as if the server fails to respond & Winscript is asking the client process whether to reconnect after the connection interrupts.
Any guidance is appreciated as we will need SSIS called through SQL server agent for this.