Hi guys,

I'm looking for a task which can export (upload) datas into a ftp server.

In Fact, I'm trying to build some automatic backups in my SQL Agent :
1. Backups my databases
2. Compress files with Winrar (command lines)
3. Transsferring compressed files to another server with FTP (the part
which is a problem for me)

Anyone can help me ?

Julien,

You cannot use the FTP task (Pull Only). You can however use ftp.exe in an
ExecuteProcess task (or batch file)

Why FTP to the other server ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Julien Foulquier" <ltopiq (AT) presence-pc (DOT) com> wrote

Thank you for your answer.

"You cannot use the FTP task (Pull Only)"
--> I'm looking for a push to backup my files into a distant server...

"You can however use ftp.exe in an ExecuteProcess task (or batch file)"
--> I tried. But a prompt request my to confirm in the case of the
destination files still exist. Do you know any way to confirm automatically
?

"Why FTP to the other server"
--> Because there is about 1000 km about my servers and I haven't an optical
fiber between them...


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> a écrit dans le message de
news:etFKgobuDHA.424 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

does turning interactive mode to off (-i) help

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Julien Foulquier" <ltopiq (AT) presence-pc (DOT) com> wrote