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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-31 : 10:28:43
|
| Todd writes "I have a large (2.5 million records) database of book Titles with one Primary Key, ISBN, and with Full-Text Indexes on several fields for web queries. Periodically we receive a CSV file with Updates and Additions to the Titles table. If there were no Update records, I could simply use DTS to import the records right in. But, because of the Update records, DTS stops at the first record that already exists because of the Primary Key constraint. My question is:Is there a simple way to use DTS and tell it if the record exists update it, else add it?I'm running SQL Server 7.00.961 on Windows 2000 Server on Dual-PIII/800 with 512MB." |
|
|
|
|
|
Inserting Incremental Updates