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 - 2003-05-15 : 07:25:26
|
| John Wayne writes "I have an doing a DTS Import of a text file to SQL DB. A field "ID" is my Primary Key. I want to append new data if the "ID" doesn't exist but if it does, I want to update the record. Can this be done through DTS and if so, how? Can this also be done through .ASP directly?" |
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-05-19 : 03:29:29
|
| Yep it can be done elegantly with multi-phase data pump. I recommend (pimp) "professional SQL Server DTS" from Wrox. You could also do it inside a package with a ActiveX script (vbscript) that uses ADO for data access. That's not too far removed from doing it with ASP. Only major fdifference would be in how you schedule the jobs. |
 |
|
|
|
|
|
Insert and Update