SSIS SFTP connection.

#1

I need to connect SFTP site to download data file. Is there any way I can
create a Secure FTP task in SSIS. If there is what is the best way to do.
If SFTP not supported natively in SSIS then is there any their party tool
that I can use?

#2

Do a search for putty sftp - I've used that successfully.

"Soung" wrote:

Quote:

I need to connect SFTP site to download data file. Is there any way I can
create a Secure FTP task in SSIS. If there is what is the best way to do.
If SFTP not supported natively in SSIS then is there any their party tool
that I can use?

#3

I found this. Haven't used it. Not cheap but there you are:

/n software SSIS Tasks - [BETA]
http://www.nsoftware.com/ssis/

Soung wrote:

Quote:

I need to connect SFTP site to download data file. Is there any way I can
create a Secure FTP task in SSIS. If there is what is the best way to do.
If SFTP not supported natively in SSIS then is there any their party tool
that I can use?

#4

Please check: http://www.cozyroc.com

We have developed very simple SFTP task with similar UI functionality to the standard FTP task. Give it a try. Cheers.

From http://www.developmentnow.com/g/103_...onnection-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS SFTP connection.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SSIS SFTP connection. - 07-28-2006 , 11:00 AM

RE: SSIS SFTP connection. - 07-30-2006 , 06:30 PM

Re: SSIS SFTP connection. - 08-12-2006 , 06:20 PM

RE: SSIS SFTP connection. - 10-13-2007 , 02:56 PM