I am battling to pass an expression in a variable
in SSIS driving me nuts
i have a simple select statement and one of the fields is s numeric (10.0)
I have a variable in SSIS which i want to use as part of the WHERE clause on this numeric field but i keep getting the following error
>>AND TCMSourceSystemID =" + @[User::TCMSourceSystemID] + "
"Data Types DT_WSTR and DT_R8" are incompatible for binary operator +
SELECT TCMSourceSystemID, SourceCustID FROM " + @[User::TargetSchema] + ".TCMStdCustomerMapSourceMULTI
WHERE TCMBusinessDate = '" + @[User::TCMBusinessDate] + "' AND TCMSourceSystemID =" + @[User::TCMSourceSystemID] + "