Hi I am trying to automate some SFTP files upload from the server and i have winscp install which i am trying to execute from the exec process task in ssis . What it does when i pass the command it opens the server and doesn't execute the Command to extract the files It just stops that means my command is Not parsed Exactly ? Here is when i run this i follow this in the executable file i use c:winscp.com in the Argument i pass this command : "abc@sftp.net" "get /home/abc/txt_20100520.zip c:\temp\" "exit" When i do try this using command line it does the same so it means my argument is NOT correct What this does it opens the command line prompt and it just stops at place where it should start execue the command get /home/abc/txt_20100520.zip c:\temp\ BUT When i do use command line and pass these all it again stops there and it requires me to write the get /home/abc/txt_20100520.zip c:\temp\ then it copies all the file to desired ( c:\temp\) can any one please advise me what should be the format or code to pass input so it can do automatically. I JUST WANT TO Pass and copy the files from server to local Please advise me this is very urgent Many thanks in advance :?dsu

Hi Dsu, "I JUST WANT TO Pass and copy the files from server to local" 8 hours passed, 43 views and still no replies. If I were you I'd consider switching to the SSIS built-in FTP-task which should be able to get what you want without using winscp and related problems. Should you face problems with this, you'd probably get more attention and help in this forum. All the best, Cees Please remember to mark the replies as answers or at least vote helpfull if they help and unmark them if they provide no help.

I am not aware of what is winscp . But if you are sure about arguments. Use the following in script task to invoke process System.Diagnostics.ProcessStartInfo i = new System.Diagnostics.ProcessStartInfo(Processname and arguments); i.CreateNoWindow = true; i.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden; System.Diagnostics.Process p = System.Diagnostics.Process.Start(i); // Start the process p.WaitForExit(); // wait until proces completes Let me know if this works .Cheers , Varun

No worries Guys,i have resolved it. Cees , Thank you my Friend for input however in ssis there is no secure FTP option available. It is Not possible to do so from ssis/2005/2008 so we do using the WinSCP tool, Its free and its okay tools, Not great But ok. Varun, we can use that method as well There is another way of doing that using t-sql we can do secure FTP as well. i AM DOING EXPERIMENT bUT asap I WILL BE ABLE TO accomplish i will post it here for others references Thanks dsu

Hi dsu, This is killing me :) Need your help guys I was asked to copy (rar) files from our WinScp to local drive Please help me to write a Execute Prcess Task in ssis to be more specific Collections is the name of our session in WINSCP Credit_SSC is the user name path of the folder in WINSCP /home/credit_ssc/payments_folder what would be arguments and executables in the task? I am not sure about these ;) Any thoughts are welcome, Thanks in advance

did you figure it out ? If not let me knowdsu