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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2001-09-22 : 21:58:18
|
| Hi there,I have a client who wishes to update data information on the webserver (sql 7.0) from a csv text file. This text file will have a batch header (as they wish to record all batch updates) and each row will have a field (lets call it command) containing "u" for update, "d" for delete, "n" for new. This system is to be designed so as to replicate data from their internal database to the web server.They will also wish to replicate data from the web server back to another text file for import to their systems.Now Im thinking of using DTS to import the data to a temp table ---> then running a stored procedure that grabs the value of the command field and performs the appropriate update,delete or insert.Would this be the best way to go? How do you grab a batch header (and trailer) for storage and then strip out data in between?Any comments or suggestions appreciated.regards,Matt |
|
|
|
|
|
importing data from a text file for replication