x

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 ?

more ▼

asked Jun 19, 2011 at 12:45 AM in Default

avatar image

aRookieBIdev
2.8k 56 65 71

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Jun 19, 2011 at 08:10 AM

avatar image

sp_lock
10.8k 27 37 37

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

Jun 20, 2011 at 06:33 AM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1219
x25

asked: Jun 19, 2011 at 12:45 AM

Seen: 1339 times

Last Updated: Jun 19, 2011 at 12:45 AM

Copyright 2017 Redgate Software. Privacy Policy