Problem solved.

I created a new variable which was a String Datatype (sUserVar)

I loaded the ResultSet into the variable (sUserVar)

I then modified the DOUBLE variable to use an Expression:

(DT_R8) @[User::sUserVar].

At this...

That sounds like a reasonable workaround.

I haven't done much with Expressions, any hints on how something like that may look?

The base is numeric(12,1)

What I meant by that statement, is that the UserVariable is used by a Web Service and it requires the variable to be a DOUBLE datatype. Thus, I don't...

Unfortunately, I have tried that and get the same results.

I have tried converting and casting to NUMERIC, FLOAT and STRING values pulling back from the SQL Server.

When I attempt to...