November 11, 2009 at 8:55 am
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
November 11, 2009 at 9:38 am
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.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply