I want to send a text file over to a ftp server via ftp.

so I use add the File Transfer Protocol Task and I see
that it only allows me to specify the source (which I
change to Directory since the text file is on my pc)

but I don't know how I could enter the IP address of the
ftp server ?

Am I doing it right ?

OK from your description it sounds like you want to put a file up to a site.
This is not possible in the stock FTP task: it is down only.

SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/Default.aspx?302)

--

----------------------------

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


"Newbie" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Here's a t-sql ftp put.
http://www.nigelrivett.net/s_ftp_PutFile.html


"Newbie" wrote:

When I want to do something that the FTP task can't do, I just run a
script, which I may write to a file using a query and BCP or ISLQ, the
batch version which has no gui. A batch file can call a script that you
write ad-hoc. just type FTP -? at the command line, and you'll see the
parameters. One disadvantage is that the script would contain the login
password. This can be mitigated by writing the script in a secure
directory, and deleting or overwriting it immediatly afterwards.

another thing I do, though it's wasteful, when sending an ftp file is to
send it, and then download what I just sent, but to a different name,
typically using the extension .CMP for compare. Then I compare the
files, and if they're byte-for-byte identical, life is good, and I can
continue. Wasteful, but hey, it's easy.