Hello,
In SSIS projects, when creating a variable, it seems the data types are
limited... I have an SQL task as follows:
SELECT SUM(Shares) AS sumshares, SUM(TransAmtUSD) AS sumusd
FROM Transactions

TransAmtUSD is defined as money type on the database, but with my SSIS user
variable sumUSDbefore defined as Double (there's no choice of float or
money),
I receive the following error when running the package:
[Execute SQL Task] Error: An error occurred while assigning a value to
variable "sumUSDbefore": "The type of the value being assigned to variable
"User::sumUSDbefore" differs from the current variable type. Variables may
not change type during execution. Variable types are strict, except for
variables of type Object. ".

Any suggestions?

Thank you,

Thomas