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 |
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
 Posted - 2004-11-23 : 07:15:49
|
| I have a "Execute SQL" task in DTS that executes SPROC. It seems that even if the stored proc fails (returns -1), the SQL execute task returns successful. I even tried to RAISEERROR with in the SPROC, but doesn't seem to help.How else do we trac erros that occured with in the sproc in DTS.any advice is greatly appreciated..thanksHemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
|
|
|
How to trap errors in Execute SQL task