InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:03:26 GMT20http://www.sqlservercentral.com/Forums/Topic1426138-148-1.aspxFor Next Step execution based on result from SP:-Double click on the Connection Arrow as success and constraint as follows @SSISVariable==1Just leave with above condition if condition not satisfied it completes the Package & gives success results.If the condition validated it goes to next Task .Mon, 04 Mar 2013 02:59:57 GMTPulivarthi Sasidharhttp://www.sqlservercentral.com/Forums/Topic1426138-148-1.aspxYou are probably looking for constraint expression.Check here [url]http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx[/url]Mon, 04 Mar 2013 02:46:52 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic1426138-148-1.aspxHi,Based on the value of a variabale getting set, I want to stop my SSIS package (successfully) without going to next tasks within the package. Can this be done? Please provide your inputs.Example: I have a stored procedure getting executed in SSIS execute SQL task. The value of output parameter of this stored procedure is getting stored in a SSIS varaible. If the value of this variable comes out as 1 then package should proceed further but if it gets set to 0, then package should stop there itself.Regards,SachinMon, 04 Mar 2013 02:38:34 GMTSachin Vaidya