1 year ago

#238170

test-img

user16334511

Trouble with WinSCP & SISS. Execute Process Task Error

I am having difficultly with grabbing data from our WinSCP site through our SSIS software. Below is the Process I currently have

Executable: C:\Program Files (x86)\WinSCP\WinSCP.exe Arguments /script=E:\SSIS\Union Street\SFTP.txt WorkingDirectory E:\SSIS\Union Street\Union Street V2

Below is the error script I receive

SSIS package "E:\SSIS\Union Street\Union Street V2\Union Street V2\Package.dtsx" starting. Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "/script=E:\SSIS\Union Street\SFTP.txt" at "E:\SSIS\Union Street\Union Street V2", The process exit code was "1" while the expected was "0". Task failed: Execute Process Task Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "E:\SSIS\Union Street\Union Street V2\Union Street V2\Package.dtsx" finished: Failure.

Any help would be grateful

sql-server

ssis

winscp

winscp-net

0 Answers

Your Answer

Accepted video resources