DTS and FTP Task

Is the FTP task in SQL Server one-way?
IOW can it only get files from the Internet and not put them to the
Internet?
For the source I can specify "internet" or "directory." For the
destination I can only specify "directory."
Thus, using the FTP task, it appears that I cannot put a file to an
internet destination. For this it appears I must call a batch file with the
appropriate ftp command string.
Can anyone confirm?Hi
The FTP task is download only.
Yes you can use the command utility to do what you require or you may want
to look at:
http://www.sqldts.com/?302
John
"Dave" <dave@.nospam.ru> wrote in message
news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
> Is the FTP task in SQL Server one-way?
> IOW can it only get files from the Internet and not put them to the
> Internet?
> For the source I can specify "internet" or "directory." For the
> destination I can only specify "directory."
> Thus, using the FTP task, it appears that I cannot put a file to an
> internet destination. For this it appears I must call a batch file with
> the
> appropriate ftp command string.
> Can anyone confirm?
>
>|||Thanks John
I have a batch file that works from the command prompt but how can I execute
that as part of my DTS package?
My SQL Task in DTS has the following command:
EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
I get a message that the command executed successfully but the file is not
uploaded.
However, from a command prompt this will upload the file just fine:
C:\>ftp -s:aol_ftp2.bat
I made sure that SQL task uses the local conmnection where my file is
located.
What am I doing wrong?
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
> Hi
> The FTP task is download only.
> Yes you can use the command utility to do what you require or you may want
> to look at:
> http://www.sqldts.com/?302
> John
> "Dave" <dave@.nospam.ru> wrote in message
> news:OkB3%23CEHFHA.3156@.TK2MSFTNGP10.phx.gbl...
>|||Never mind:
This works...
EXEC master..xp_cmdshell 'ftp -s:C:\aol_ftp2.bat'
"Dave" <dave@.nospam.ru> wrote in message
news:%23ipII3EHFHA.3076@.tk2msftngp13.phx.gbl...
> Thanks John
> I have a batch file that works from the command prompt but how can I
execute
> that as part of my DTS package?
> My SQL Task in DTS has the following command:
> EXEC master..xp_cmdshell 'C:\ftp -s:aol_ftp2.bat'
> I get a message that the command executed successfully but the file is not
> uploaded.
> However, from a command prompt this will upload the file just fine:
> C:\>ftp -s:aol_ftp2.bat
> I made sure that SQL task uses the local conmnection where my file is
> located.
> What am I doing wrong?
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OlQVnREHFHA.1996@.TK2MSFTNGP12.phx.gbl...
want[vbcol=seagreen]
with[vbcol=seagreen]
>