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 |
|
kvangor
Starting Member
13 Posts |
 Posted - 2005-01-18 : 13:57:33
|
| Hi All:We use DTS to load our datawarehouse. Our DTS load package is scheduled to kick off at the same time every night. Within the DTS package, we have an On Error task at each major step which sends out an email informing us where the package failed. Well, last night our build failed, and our final "Completion" email still went out to the users. Needless to say we weren't the most popular people this morning. The step failed with an "unable to bind to table" error which can be seen when viewing the job history on that particular step. I can't figure out why DTS didn't catch this error or if it's even possible to do so. We'd like the build to either stop and send out an alert at that point, or restart that particular step, but not to go on and finish processing.Is this possible with this sort of error???? We've had this happen a number of times over the past few months...SQL Server 2000Thanks in advance for any assistance!Kevin |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-01-18 : 19:21:05
|
What does your workflow "precedence" look like, do you have the package option set to fail package on first error. Check to make sure every process has an On Success path so that your dts can not launch any process without all previous being completed. If you run the DTS through the scheduler, make sure you set the steps to On failure Quit with failure. |
 |
|
|
|
|
|
DTS Error handling