|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: Friday, January 15, 2010 10:56 PM
Points: 43,
Visits: 182
|
|
Hello All,
I have a DTS package with multiple tasks executing one after another in an order. One of the task (in middle) in my DTS package is an ExecuteSQL task which pulls data from an Oracle datasource. I have a requirement where I want to abort the package or reexecute the package again after 30 min if the ExecuteSQL task I mentioned above doesnot return any rows. Could anyone please let me know how can I achieve this.
Your help is appreciated.
Thanks,
-Amith Vemuganti
|
|
|
|
|
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:24 PM
Points: 8,665,
Visits: 4,943
|
|
You can add conditional handlings to the flow-control objects in DTS. Right-click the green arrow (the flow-control object), and I think you then go to Properties and walk through from there. (It's been a while since I used the DTS editor. Much more accustomed to SSIS these days.)
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
|
|
|
|
