I have a sp where a cursor get a record from table1
and insert into table2.
I handle the error 2627 (Violation of PRIMARY KEY constraint .. )
so that the cursor move to the next valid record
in order to do the correct insert.

The sp works and I am glad of that but ...

when I call the same sp from a DTS (in Execute SQL Task ) with exec
usp_DialogoSmartStream_Remedy
the DTS fails as soon as sp raises the 2627 error

How do I do to avoid DTS failed ?

Thanks :..


--
Hammer - One shot, one kill

Inviato da www.mynewsgate.net