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 |
|
woodyuk
Starting Member
1 Post |
 Posted - 2005-08-15 : 05:04:49
|
| HiI have a project that needs to do the following, and wondering the best way is and if its possible.Have a table with various data, over time the data gets "used" up. records get marked as used. The table has to be given new data. The ONLY way this can be done is to get new data from a remote FTP Server.My thinking was a DTS with FTP that connects to a FTP Server, checks for a file of a certain name. if it finds it, downloads to local sqlserver, ideally the format of this file would be XML. I then import the XML into the data and now I have new data. Addiotnally each night I need to send a XML file from the sqlserver saying what data is left in the table (that is how my central FTP Server) knows to create a new data file for me. I cannot use anything other than FTP as my connection method :-(I am happy to code the logic in C++ (DLL) (upload/downloadFTP, XML parser<>SQL) and call via TSQL in a stored procedure - Was wondering though if I can do all of this using SQLServer2000 and DTS out of the box ? not a SQLSever guru ;-(Thanks for any advice |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-08-15 : 16:48:10
|
| Seehttp://www.mindsdoor.net/#FTPIt will get the directory listig from the ftp site allowing you to process each file.It also shows how to send a file to an ftp site an retrieve a file.This is from SPs using ftp.exe.==========================================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. |
 |
|
|
|
|
|
FTP and SQLServer2000