CODEWITHSUNDEEP
ssis
user3801452
user3801452

Reputation: 5

FOR Loop container in SSIS 2012

I am using the FOR LOOP container in SSIS 2012. I want this Loop to execute unless the value of a Boolean variable that I have is FALSE. However when I try to set the EvalExpression property of the For Loop container I get an error: Cannot convert 'System.Boolean' to 'System.String'. I set the expression as:

@[User::myVar] = FALSE

How can I set the expression so that if the value is false then I break out of the FOR LOOP?

Upvotes: 0

Views: 1897

Answers (1)

billinkc
billinkc

Reputation: 61201

You have one to two issues.

The first is that myVar must be of type Boolean

The second and more insidious is that you are assigning a value = of False to your variable. What you want to do is test whether your variable is False. The comparison operator is ==

enter image description here

Upvotes: 2

Related Questions