Link to home
Start Free TrialLog in
Avatar of sqlcurious
sqlcuriousFlag for United States of America

asked on

SSIS error

Error: 0xC0029151 at Upload to SFTP, Execute Process Task: In Executing "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-ExecutionPolicy Unrestricted -file "\\dsetl\d$\Powershell\WinSCP_SFTP_FileUpload.ps1" "\\dsetl\d$\SSIS\WinSCP\WinSCPnet.dll" "Sftp" "passive" "none" "22" "mcty-8-jfd8q6mxnt9pfcnd42dq4.ftp.marketingcloudops.com" "70479" "ET123!" "ssh-rsa 2048 ypSoIuzwzTskowWJDqNud7RU9Q4rlzLQ6RQvVIxz5sM=" "" "/Import/" "CustomerInfo_ET.zip" "\\heritagecoin.com\shares\Data Services\ExportData\ExactTarget_DevUploads\\" "CustomerInfo_ET_Olivia.zip" "true"" at "", The process exit code was "-196608" while the expected was "0".
Task failed: Upload to SFTP
Warning: 0x80019002 at CustomerInfo_ET: SSIS Warning Code
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

A couple of comments:

It would be helpful if you could paste the contents of your WinSCP_SFTP_FileUpload.PS1 script to this thread.
Your post appears to include real usernames and passwords along with company-identifying information.  You should modify your post to remove this information and replace it with the literal word "username" and "password" where applicable.
Using code blocks will help with readability of your post:
Error: 0xC0029151 at Upload to SFTP, Execute Process Task: 
In Executing "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe"
 "-ExecutionPolicy Unrestricted -file "\\dsetl\d$\Powershell\WinSCP_SFTP_FileUpload.ps1"
 "\\dsetl\d$\SSIS\WinSCP\WinSCPnet.dll" "Sftp" "passive" "none" "22" "sftphost.mycompany.com"
 "username" "password" "ssh-rsa 2048 myCryptographicKey" "" "/Import/" "CustomerInfo_ET.zip"
 "\\destination.com\shares\somefolder\someotherfolder\ExactTarget_DevUploads\\"
 "CustomerInfo.zip" "true"" at "",
 The process exit code was "-196608" while the expected was "0".
Task failed: Upload to SFTP
Warning: 0x80019002 at CustomerInfo_ET: SSIS Warning Code

Open in new window

This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.