February 18, 2003 at 6:02 am
Hi,
I need to download every day one PriceList from internet and to update a table in my database.What is the best method to do this with Sql Server 2000?
Thanks a lot,
Jelena
February 18, 2003 at 6:14 am
It depends! What format does the data arrive in? Basically you need to figure out how to connect to get the data (FTP, web service, screen scrape, whatever) down locally, then possibly transform it into a more useable format, then run one or more queries to do add/update/deletes to your data. You can probably do it in DTS, or depending on the complexity, may make sense to write as a standalone app.
Andy
February 18, 2003 at 6:45 am
The data arrive in .txt format, but my problem is how to connect client every day to that internet adress and download file?
I think there wili be no problem to convert data from file using DTS.
Jelena
February 18, 2003 at 7:28 am
If the client exposes an FTP server, use FTP to transfer the file from the client. Execute a batch script using a scheduled job in NT/2000. Also, you could use the wininet.dll to do FTP work in a scheduled Windows .exe...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply