I wanna upload file automatically to my client server on daily basis through SFTP SSIS task ...In past i have downloaded the files using WinScp but i dont know how to push(upload) file daily using SFTP SSIS Task .. I dont wanna use/buy any third part tools and i am not expert in .net or VB code.So do you think it is still possible ? Thank a ton in an advance ...for your help !!!!.*) ..) .*) (. (. . (.* *..`> Krunal

I wanna upload file automatically to my client server on daily basis through SFTP SSIS task ...In past i have downloaded the files using WinScp but i dont know how to push(upload) file daily using SFTP SSIS Task .. I dont wanna use/buy any third part tools and i am not expert in .net or VB code.So do you think it is still possible ? Thank a ton in an advance ...for your help !!!! .*) ..) .*) (. (. . (.* *..`> Krunal No, it is not. You have to either write code or use third-party tools.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

what about below steps ? a) Create a configuration file. b) Create a .bat file like "C:\Program Files\WinSCP\winscp" /script="<>\SCPconfiguration.config" > "C:\AmexFTPFiles\log.log" @echo off if %ERRORLEVEL%== 0 echo ***SUCCESS*** if %ERRORLEVEL%== 1 echo ***FAILURE*** pause This is code for .bat file which i have scheduled via the job. c) The configuration file have the winscp commands like # Automatically answer all prompts negatively not to stall # the script on errors option batch on # Disable overwrite confirmations that conflict with the previous option confirm off # Connect using a password # open user:password@example.com # Connect open <SFTP IP># Change the remote directory cd /inbox # Upload the file to current working directory put <FilePath>\*.txt # Disconnect close exit Create the SFTP IP via the UI provided by Winscp check for the connection can be opened via the client, also ensure the port 23 is open, which is the SFTp port. The first step is to get the connectivity up and running via winscp, on the client side, and then do the steps mentioned. .*) ..) .*) (. (. . (.* *..`> Krunal

These steps worked fine for me. Bring in an Execute Process Task to run this script and the files should upload with no problem.

you can write your own code in SCRIPT Task to upload file with SFTP, here is an example of such code: http://saravanandorai.blogspot.co.nz/2012/01/sftp-and-file-upload-in-sftp-using-c.htmlhttp://www.rad.pasfu.com

Hello, Follow the links below. It may help you. http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/709CA5B8-3178-4E57-B943-47802FE52408 http://www.codeproject.com/Articles/23740/SFTP-with-SSIS-Packages