Paralle Processing

Question

Hi Following is my problem.
1. I have one for Loop container. It have Data flow task, Execute SQL Task1 and Execute SQL Task2 as children.
2. Execute SQL Task1 is connected by Success Precidenc Constrain with Execute SQL Task2.
3. So I have two parallel flows in for Loop container.
4. Data flow task is there to fetch large number of rows from one table to other.
5. in Execute SQL Task1 I am waitng for 15 sec. (WaitFor Delay '00:00:15') 
6. In Execute SQL Task2 I am making it fail by SELECT CONVERT(int,'abc')
7. For Execute SQL Task2, FailParentOnFailure = TRUE
8. so my assumption is that the For loop will fail in 15 sec.
9. But even if Execute SQL Task2 is failing, For Loop container is waitng for Data flow task to complete its execution.
10. After DataFlow Task's completion only For Loop is failing.
11. But I want For Loop to fail, instantly after Execute SQL Task2 fail.

Please forward your comments.....

Waitng.......

Waitng.......

Still waiting.... :(

Answer 1

Moving to the SSIS forum. 

---

Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

Answer 2

Not really sure what to say to this one except that this is expected behaviour.

-Jamie

---

http://sqlblog.com/blogs/jamie_thomson/ | http://jamiethomson.spaces.live.com/ | @jamiet

Answer 3

If you have 2 tasks that start simultaneously and one of them fails while the other is executing, the parent container won't fail until the second task either completes or fails. perhaps if you describe your goal we could help on providing alternate approaches.

---

Rafael Salas | Don’t forget to mark the post(s) that answered your question http://rafael-salas.blogspot.com/

Answer 4

Agasti,
This is an expected behaviour. If you want to fail for loop container(Parent) try applying the (WaitFor Delay '00:00:15') in the for loop container and fail the component by some custom failure methods.

Post back your requirement for exact solutions.

---

Thanks, Bharani M - Please mark the post as answered if it answers your question. - Please vote the post as Helpful if you find the post as helpful.