July 31, 2014 at 12:36 am
Hi ,
Let me know how to resolve the problem
There are two tasks Task A & Task B which runs parallely . Task B Runs less than 3 Seconds and Task A Runs more than 30 Min.
If Task B Fails , the running Task A should stop and package Should fail to run .
Thanks
Surya sunil
July 31, 2014 at 12:50 am
Hmmm, seems difficult to do out of the box.
Maybe you could add some task after Task B that kills the SSIS process in some manner, but that seems quite dangerous to me.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2014 at 12:51 am
Just one more thought: if task B takes less than 3 seconds, what's the point of having them run in parallel?
Just run task B before task A with a precedence constraint.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2014 at 12:58 am
Actually , I simplified problem .. coming to real scenario ...
Task A getting hanged ( Could not able to sort out solution) . As work around, Task B has been added , which runs for 5 min in loop by checking whether Package completed or not . If Package runs more than 5 Min , I am trying to fail package . If package runs successfully less than 5 min , loop will break .
July 31, 2014 at 1:13 am
sunil.mvs (7/31/2014)
Actually , I simplified problem .. coming to real scenario ...Task A getting hanged ( Could not able to sort out solution) . As work around, Task B has been added , which runs for 5 min in loop by checking whether Package completed or not . If Package runs more than 5 Min , I am trying to fail package . If package runs successfully less than 5 min , loop will break .
I see. Maybe you should start your questions with the actual scenario next time.
There is no possible way to do this from within SSIS.
Execute your package in a SQL Agent job and monitor its execution with another job.
If you go over 5 minutes, kill the Agent job.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2014 at 1:17 am
:crying:
August 4, 2014 at 6:05 am
Is this possible solution at high Level . PFA
August 4, 2014 at 6:18 am
sunil.mvs (8/4/2014)
Is this possible solution at high Level . PFA
It seems like it could work. Haven't implemented anything like this myself.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply