sftp

#1

has anybody ever used sftp to tansfer file? is there a way to do this in
sqlserver 2000 and/or sqlserver 2005?

thanks in advance.

#2

SQL Server itself doesn't know what FTP (or sftp) is. I think that SSIS
might have an FTP task... and while I am no SSIS guru, my guess is that for
sftp you'd have to call a program via the command line to achieve it...

"lark" <lark (AT) buysurething (DOT) com> wrote

Quote:

has anybody ever used sftp to tansfer file? is there a way to do this in
sqlserver 2000 and/or sqlserver 2005?

thanks in advance.

#3

SQL Server itself doesn't know what FTP (or sftp) is. I think that SSIS
might have an FTP task... and while I am no SSIS guru, my guess is that for
sftp you'd have to call a program via the command line to achieve it...

"lark" <lark (AT) buysurething (DOT) com> wrote

Quote:

has anybody ever used sftp to tansfer file? is there a way to do this in
sqlserver 2000 and/or sqlserver 2005?

thanks in advance.

#4

Aaron is spot on, in SSIS you need to call a 3rd party sftp program
using the ExecuteProcess task.

Good luck!
J

#5

Aaron is spot on, in SSIS you need to call a 3rd party sftp program
using the ExecuteProcess task.

Good luck!
J

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

sftp

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

sftp - 05-19-2008 , 12:40 PM

Re: sftp - 05-19-2008 , 02:29 PM

Re: sftp - 05-19-2008 , 02:29 PM

Re: sftp - 05-21-2008 , 03:46 AM

Re: sftp - 05-21-2008 , 03:46 AM