<div>
Not sure what's the 100% correct syntax, but i think you should convert your number to a varchar type or something like that ...<br />
<br />
... + cast(@[User::TCMSourceSyst<wbr />emID] as nvarchar(50)) ...
</div>


Not sure what's the 100% correct syntax, but i think you should convert your number to a varchar type or something like that ...

... + cast(@[User::TCMSourceSystemID] as nvarchar(50)) ...

<div>
Hi,<br />
i cannot as it is numeric in the database, so not sure why i am getting this error<br />

</div>


Hi,
i cannot as it is numeric in the database, so not sure why i am getting this error


<div>
You are using string concatenation to create your sql-statement, so everything has to be text to be concatenated with the rest of the statement. You can and should convert!
</div>


You are using string concatenation to create your sql-statement, so everything has to be text to be concatenated with the rest of the statement. You can and should convert!

<div>
<div class="content wysiwyg-content">
Hi <br />
I am battling to pass an expression in a variable <br />
in SSIS driving me nuts<br />
i have a simple select statement and one of the fields is s numeric (10.0)<br />
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 <br />
<br />
&gt;&gt;AND TCMSourceSystemID =&quot; + @[User::TCMSourceSystemID]<wbr /> &nbsp;+ &quot;<br />
<br />
&quot;Data Types DT_WSTR and DT_R8&quot; are incompatible for binary operator +<br />
<br />
thanks<br />
<br />
<br />
&quot;<br />
SELECT TCMSourceSystemID, SourceCustID &nbsp;FROM &quot;&nbsp;+ @[User::TargetSchema] + &quot;.TCMStdCustomerMapSourceM<wbr />ULTI<br />
WHERE TCMBusinessDate = '&quot; + @[User::TCMBusinessDate] &nbsp;+ &quot;' AND TCMSourceSystemID =&quot; + @[User::TCMSourceSystemID]<wbr /> &nbsp;+ &quot;<br />
&quot;
</div>
</div>


Hi 
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 +

thanks


"
SELECT TCMSourceSystemID, SourceCustID  FROM " + @[User::TargetSchema] + ".TCMStdCustomerMapSourceMULTI
WHERE TCMBusinessDate = '" + @[User::TCMBusinessDate]  + "' AND TCMSourceSystemID =" + @[User::TCMSourceSystemID]  + "
"

SSIS Expression problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.