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

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

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.