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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Upload tables from a server to an FTP site using DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-12 : 07:14:27
John writes "I am running an application running SQL Server 2000 and Windows 2000. I want to create a DTS package that simply copies two tables to an FTP site of which I have the credentials. I found a very easy way to download FROM an FTP site, but cannot find a way to upload TO an FTP site. Can anyone help?

Thank you very much
John Lloyd"

nr
SQLTeam MVY

12543 Posts

Posted - 2005-07-12 : 09:12:36
Use an SP.
see
http://www.mindsdoor.net/FTP/s_ftp_PutFile.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -