Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2002-03-06 : 10:57:49
|
With DTS in SQL2k there is an FTP task that allows you to connect to an internet site as the source and pull files down to a folder.Is there a task that allows for transferring from a local folder to an FTP internet site? or do I have to buy SQL XP when that comes out...  It would seem quite silly to have the ability to get files from FTP in DTS but then not have the ability to put files to an FTP site in DTS.All I want to do is xfer the results of a query to an FTP internet site using DTS... So if it can be done without vb/java script then please let me know.DanielSQL Server DBA |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-06 : 11:18:44
|
| Don't know if you can do it via DTS ftp task (I believe you can't), but you could use command-line ftp instead. Just generate a batch file with the necessary FTP commands, and pass it as an argument to the command-line FTP. |
 |
|
|
|
|
|
DTS FTP transfer to an internet site