question

kishoremcp avatar image
kishoremcp asked

SSIS Script Task to download .txt file from SFTP

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.
ssisscript-tasksftp
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What version of SQL Server/SSIS are you using?
0 Likes 0 ·

1 Answer

· Write an Answer
ravirobin avatar image
ravirobin answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.