Downloading, decompressing and adapting file

Need to do this to set up DTS

[bateman_ap]

Hi, been struggling all weekend on this one, what I am trying to do is set up something for every 2 days download a archive file from a http site, decompress it, and then perform a couple of search and replaces on the .csv file it produces before I run the DTS script I have set up in SQL server (I managed to do that bit!)

The steps will have to be

1. Download from [domain.com...]
2. Save in C:/database_csv/
3. Perform a search and replace of ', ' to ','
4. Perform a search and replace of \' to nothing
5. The DTS script should now use this to update my SQL database.

Anyone know the best way to do steps 1-4, the server is W2K server

[wardbekker]

You could let DTS execute a script or a home-made program that does just that. When finished, parse the csv result.

See xp_cmdshell for executing another program from sql server