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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2005-10-07 : 06:15:12
|
| Hi All,Does anyone know how to check the status for each task by using ActiveX script? I would to do something like:- check whether the execution of DTSTask_DTSDataPumpTask_1 is success or fail? - If success then do something- If fail then do other thing.If anyone know, can you please teach me how to do it? Thank you. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-10-07 : 06:18:03
|
Why do you want to use an ActiveX task - when the workflow does this for you already?Duane.  |
 |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2005-10-09 : 23:03:45
|
| Hi Ditch,Thank you for your reply. Do you mean the onFailure event in the workflow? I have a lot of tasks in my DTS package and each task is only started upon successful execution of the previous task. If I've to use the onFailure workflow, I will end up creating a lot of onFailure branches, am I right? I'm thinking whether we can create an ActiveX script to check the status for each task whether it is success or fail? If fail, then compile an email and send it as a notification to Administrator. Do you think this will work? Or is there any better way to achieve this? The purpose is to capture the failure task and send a notification to Adminstrator to inform him/her the reason of the failure.If anyone have any idea how to do this, please teach me how to do.Thank you in advance for the help.Regards,William |
|
|
|
|
|
|
Check each task whether is it success or fail?