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 |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2007-09-10 : 17:12:24
|
| There are multiple Transform Data Tasks in a DTS Package. They transfer data individually. I tried to use one Execute Process Task. If one of the Transform Data Tasks fails, the Execute Process Task supposes to execute an .exe to send email notification. The problem is if one Transform Data Task fails, the Execute Process Task doesn't run. Any idea how it supposed to work?Thanks.DanYeung |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-10 : 17:37:48
|
| You need to handle this with workflow.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2007-09-10 : 18:24:32
|
| I had all Transform Data Task on Failure go to the same Execute Process Task using Workflow, but if only one failed and all others were success the Execute Process Task didn't run. Do I have to use one Execute Process Task for each Transform Data Task? There are over 100 Transform Data Tasks in the DTS Package. Thanks.DanYeung |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-10 : 18:36:39
|
| Could you post a picture of the DTS package? We don't need to see all of the Transform data tasks, just some of them with the workflow and the execute process task.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2007-09-10 : 19:15:27
|
| How do I post a picture or attach an image file? Thanks.DanYeung |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-10 : 19:25:53
|
| You would need to post it on a website where you have access to upload files.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Use one Execute Process Task for multiple tasks