title: How can i use int32 variables Expression builder in SSIS
body: <p>In the expression builder, my query looks something like this. </p>
  
  <pre><code>SELECT *
  FROM TABLE_A
  WHERE COLOMN_A_ID IN 
                  (SELECT COLOMN_A_ID 
                   FROM TABLE_B 
                  JOIN EXTRACT_STATUS  ON   EXTRACT_DTTM &gt;  TO_DATE('" + (DT_WSTR, 30) @[User::LastTransferDT] + "', 'mm/dd/yyyy hh:mi:ss AM') AND TABLE_B.Scheduled_DT BETWEEN EXTRACT_STATUS.RANGE_BEGIN_DTTM AND EXTRACT_STATUS.RANGE_END_DTTM AND F_MPOG_EXTRACT.extract_num ="+@[User::RowNumber]+ ")"`
  </code></pre>
  
  <p>I keep getting the same error again and again. 
  Please help.</p>
  
  <hr>
  
  <h2>TITLE: Expression Builder</h2>
  
  <p>Expression cannot be evaluated.</p>
  
  <blockquote>
    <p>For help, click: 
    <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202010&amp;ProdVer=10.0.40219.1&amp;EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&amp;EvtID=FailToEvaluateExpression&amp;LinkId=20476" rel="nofollow noreferrer">http://go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202010&amp;ProdVer=10.0.40219.1&amp;EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&amp;EvtID=FailToEvaluateExpression&amp;LinkId=20476</a></p>
  </blockquote>
  
  <hr>
  
  <p>ADDITIONAL INFORMATION:</p>
  
  <p>The data types "DT_WSTR" and "DT_I4" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.</p>
  
  <p>Attempt to set the result type of binary operation </p>
  
  <pre><code>SELECT *
  FROM TABLE_A
  WHERE COLOMN_A_ID IN (SELECT COLOMN_A_ID
                       FROM TABLE_B
                            JOIN EXTRACT_STATUS
                               ON     EXTRACT_DTTM &gt;
                                        TO_DATE('" + (DT_WSTR,30)@[User::LastTransferDT] + "', 'mm/dd/yyyy hh:mi:ss AM')
                                  AND TABLE_B.Scheduled_DT BETWEEN EXTRACT_STATUS.RANGE_BEGIN_DTTM
                                                               AND EXTRACT_STATUS.RANGE_END_DTTM
                                  AND F_MPOG_EXTRACT.extract_num =" + @[User::RowNumber]" failed with error code 0xC0047080.
  </code></pre>
  
  <p>(Microsoft.DataTransformationServices.Controls)</p>
  
  <hr>
  
  <p>BUTTONS:</p>
  
  <h2>OK</h2>