question

aRookieBIdev avatar image
aRookieBIdev asked

SFTP in SSIS

How do we do a SFTP in SSIS package?I know SSIS supports only ftp and we need to write some script to do a sftp.Is there any simple way ?
ssisfile
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
sp_lock avatar image
sp_lock answered
You have a few options.. One is tools like [CozyRoc][1], it has its own SFTP task to make things simple. Another is to use WINSCP and shell out using the [scripting][2] components it allows you to carry out. Or, just a quick search brough up SSC [article][3] [1]: http://www.cozyroc.com/ssis/sftp-task [2]: http://winscp.net/eng/docs/scripting#using_scripting [3]: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/69931/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

DaniSQL avatar image DaniSQL commented ·
I use WinSCP too and its works well for me and easy to script.
0 Likes 0 ·

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.