On Thu, 19 Feb 2004 00:14:55 GMT, "mountain man"
<hobbit@southern_seaweed.com.op> wrote:
"jt" <fo*@bar.org> wrote in message
news:40***********************@newsread2.arcor-online.net... Hi moutain man,
thanks for the input.
But how do I supply credentials for the ftp site ( username password )
within a CmdExec task ?
In the absence of further information, not having previously ftp'd
out of SQL server, my inclination would be to find some ftp.exe
which will accept parameters (eg: input and output locations, account
credentials and p/w's, and run it via a batch file, passing the appropriate
params into it from the batch file.
If there are other solutions out there, someone should pipe up
sooner or later.
Good luck!
The windows/dos ftp client can be scripted. We do this at work.
It's easiest if everything is constant, by which I mean I always want
to ftp a file with a fixed name to a fixed location.
the script (a text file) will look something like
open ftp.foo.com
user: fred
pass: fred
cd /public/upload
put c:\temp\myfile
quit
basically it's just a list of commands that you would type in at the
keyboard to achieve your result.
and the scheduled job is like ftp < myscript.txt
If the filename varies then you might need to use mput with a wildcard
instead of put, but that is the gist of it.
The above might not be the exact syntax, as this is from memory. Post
or mail again if you have problems and I'll find some live code.