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 |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2010-06-04 : 12:20:07
|
| i use SQL 2000i have a procedure that inserts data insert data from table1 to table2I use datatransformtionservice (dts) that performs (execute) my procedure dailyMy table 2 have a keyIf i have an error, the dts is canceled (not continue)But if i execute the procedure with query analiser, the system return an error but continueHave you an explanationExcuse my english |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-06-04 : 14:14:52
|
| What kind of error are you receiving? |
 |
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2010-06-08 : 05:59:17
|
| if the system detect 2 same records, it returns (can not insert record exist)and cancel |
|
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2010-06-08 : 06:01:20
|
| the error is normalbut the question is (why it cancel with DTS and continue with query directly) |
|
|
|
|
|
|
lot DTS