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 |
|
ch9862
Yak Posting Veteran
76 Posts |
 Posted - 2007-02-27 : 09:33:56
|
| I have a DTS package that populates database in number of steps. First step clears the table, second brings columns from one source, third populates columns from another source, and so on. When this is all done, last step enters "table X done" into log table. All these steps are connected via "on success".I also want to log an error (e.g. "table X load failed"). Since I have number of steps that could fail, I connected each of them to the "failure" step via "on error" - which produced weird looking web of red and white connections =). Is this the way to do it, or is there a shourtcut that makes package look less cluttered?Edit: I mean something like an error handler, where I could say "if ANY of the steps in this package fail, do X".TIA |
|
|
|
|
|
Error handling