Using the Execute Process Task to FTP files
-
I have an SSIS package that will transfer data files from the Windows server to a Unix server. Before developing the SSIS package, I wanted to make sure that I had the correct syntax to tranfer the files. From the DOS command line, I was able to successfully transfer the files, using SSH Tectia's software. The following is the syntax that I used for that transfer:
sftpg3 -P <port number> -B <batch file name> <user_name>@<sever_name>/<user_name>
The following values are used in the Execute Process Task, on the Process tab:
- Executable: <path_name>\sftpg3.exe
- Argument:
sftpg3 -P <port number> -B <batch file name> <user_name>@<sever_name>/<user_name>
After running the package, I received an error, complaining about the above syntax: The process exit code was "4" while the expected was "0".
I'm not quite sure why I cannot use the exact same command within the Execute Process Task. I also tried using the FTP Task and was unable to successfully establish a new connection.
If there is anyone who knows the solution to this problem, please share it with me - I would greatly appreciate it.
Thank you.
-
We use the ExecuteProcess Task to FPT files to an MSP using sslftp. I wrote a cmd file that is called in the Execute Process Task that uses a script to transfer the files. The only other issue I had getting the process to work was I had to write this package on the server where it runs. I could not get it to run properly when I tried to develop the SSIS package on my development workstation.
- Executable <A href="file://\\\Export\SchoolNet\Schripts\SchoolNetXfer.cmd">\\<Server>\Export\SchoolNet\Schripts\SchoolNetXfer.cmd
Working Direectory D:\Export\SchoolNet
FailTaskIfReturnCodeIsNotSuccessValue True
hth
-
Thank you very much for your response, Lynn. I will review your command file and try to write the package on the server.
Thanks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply