Execute SQL task
I do not want my Execute SQL task to stop on failure, want to keep on going by ignoring failure, can someone help me as to what do I need to set in order to ignore failure? Thansk for your help and time Nimisha
February 28th, 2011 11:26pm
what do you mean by Ignoring failure? do you want to go on other tasks in case of failure? if yes, just use On Failure precedence constraint. also you can raise up MaximumErrorCount property.http://www.rad.pasfu.com
February 28th, 2011 11:40pm
Hi, What you can do is use the precedence constraint as On completed if the Execute SQL task failed then also it will move to next control. Thanks, Shobhit Please mark as answer if this post helps.
February 28th, 2011 11:58pm