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-07-02 : 07:17:25
|
| Yossi writes "Can DTS be made to do an update when a record is already found?Until now I have tried using the Transform Data task, But this seems to be an Insert only function. I would like to be able to take my data insert all new records and if an error occurs (i.e a records is already there) then to update the changed fields?Is this possible?ThanksSQL 2000 Service PAck 3aWindows 2000 Server." |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-07-02 : 09:30:10
|
| You're better off writing a data pump task to a staging table, and then running the inserts/updates from a stored procedure.Jonathan{0} |
 |
|
|
|
|
|
DTS Updates