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 ?

asked Jun 19 '11 at 12:45 AM in Default

aRookieBIdev
2k ● 24 ● 40 ● 46

(comments are locked)

1 answer:

You have a few options..

One is tools like CozyRoc, it has its own SFTP task to make things simple.

Another is to use WINSCP and shell out using the scripting components it allows you to carry out.

Or, just a quick search brough up SSC article

answered Jun 19 '11 at 08:10 AM

sp_lock
8.1k ● 20 ● 26 ● 29

I use WinSCP too and its works well for me and easy to script.

Jun 20 '11 at 06:33 AM DaniSQL

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

ssis x751
file x17

asked: Jun 19 '11 at 12:45 AM

Seen: 726 times

Last Updated: Jun 19 '11 at 12:45 AM