how to stop the package based on a condition?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » how to stop the package based on a condition?...

how to stop the package based on a condition?

Rate Topic

Display Mode

Topic Options

Author

Message

Sachin Vaidya

Posted Monday, March 04, 2013 2:38 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:59 AM
Points: 61, Visits: 197

Hi,

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,
Sachin

Post #1426138

joeroshan

Posted Monday, March 04, 2013 2:46 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 12:43 AM
Points: 574, Visits: 1,176

You are probably looking for constraint expression.

Check here
http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups

Post #1426140

Pulivarthi Sasidhar

Posted Monday, March 04, 2013 2:59 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 1:01 AM
Points: 872, Visits: 524

For Next Step execution based on result from SP:-

Double click on the Connection Arrow as success and constraint as follows

@SSISVariable==1

Just leave with above condition
if condition not satisfied it completes the Package & gives success results.

If the condition validated it goes to next Task .

Post #1426149

« Prev Topic | Next Topic »

Permissions