all groups > sql server dts > july 2007 >
You're in the

sql server dts

group:

Failing a SSIS using an If statement


Failing a SSIS using an If statement S
7/25/2007 1:23:29 PM
sql server dts:
I create a Execute task that sets a boolean value of whether or not to
continue the processing of the package How do I evaluate that
variable to determin whether to continue of fail. In DTS I would have
written and ActieX script and giving it a status code but I do not see
the same function in SSIS

Basiclly I need something along this

if (@[User::IsScored] == true){
'Continue
return 1;
}else{
'Fail
return 0;
}
RE: Failing a SSIS using an If statement Todd C
7/28/2007 10:36:00 PM
Hello,

On your control flow, have a step that sets the value of the variable by
whatever means you are doiing. From there, connect to a dow-stream Control
Flow task with the arrow. Right-click on the arrow and choose Conditions. Set
your conditions there.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


[quoted text, click to view]
AddThis Social Bookmark Button