Hi, I have an sftp link where I am able to login and download the .txt file (Latest). I am looking for an SSIS package where I can use only script task to get this task done. If it has multiple .txt files, it needs to pick the latest file only and transfer it to a local folder. (ex: c:\kishore\sftp\) Please help me. I am new to this and i am not supposed to use any WinSCP kind of tools to get this done.
If you work with any C# developer, you can ask for some help. But this approach take a long time and every time you have a SFTP task, you will run into a wall. SSIS doesn't connect to SFTP out of box. I would suggest convince your boss to purchase SSIS extension package (CozyRoc or TaskFactory). You can tell your boss it's cheaper to buy these extensions than program it yourself. CozyRoc SSIS extension work great. I used them at previous work. It's $400/year for two server licenses. You don't need it for your workstation. PragmaticWorks' Task Factory (which I am using now) is also good. You only need server license. It's 3 times more expensive than cozyroc, but the support and interface is nicer.