SSIS Script task int32 variable comparison

Question

I am using VS 2008

so I have two variables count_a and count_b declared as Int32 variables in the package scope I have added the two variables in the ReadOnlyVariables list of the Script Task Editor

my code inside the script task looks like this:

        if (Dts.Variables["count_a"].Value == Dts.Variables["count_b"].Value)
        {
             //do something
        }
        else
        {
             //do something
        }

the default value for both variables is zero. when I step through the code I see that both variables have a zero value but when evaluating this expression: Dts.Variables["count_a"].Value == Dts.Variables["count_b"].Value

I get a false

any one seen anything like this before

appreciate any suggestions

billinkc · Accepted Answer · 2014-02-06 15:18:07Z

2

You aren't comparing 0 to 0. You are comparing the memory address of count_a to count_b. You'll need to access the .Value property of the object to get the value. Note that you would need to cast the Value into a primitive type. For the comparison you're performing, .Value.ToString() would suffice

answered Feb 6, 2014 at 15:18

billinkc

61.4k10 gold badges110 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2129585 Over a year ago

ahhh that makes sense just realized the type is object for .value ... thank you

Collectives™ on Stack Overflow

SSIS Script task int32 variable comparison

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related