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 |
|
dith
Starting Member
24 Posts |
 Posted - 2001-02-28 : 14:42:41
|
| How do I continue to execute a DTS package eventhough it encounters an error on one part of the package? This is how it goes... I created a table with a unique index and set it to "ignore_dup_key". In my DTS package, I automated the insert of rows into that table (say tableA) from another table (tableB). But tableB is sure to have duplicate rows. After inserting rows into tableA, my package stops execution and shows the error "Duplicate key ignored." I still would like the package to continue execution, since I'm already expecting it to ignore duplicate rows. How would I do this? Thanks in advance,Dith |
|
|
|
|
|
Error handling