title: Cannot parse my SSIS derived column expression
body: <p>Hi this is my first time trying to write a complicated derived column expression. I'm not sure what the problem is as it's a pretty generic error message which doesn't help much,</p>
  <p>The expression is:</p>
  <pre><code>If( [conv_Status] ==10 &amp;&amp; [conv_Agreed] == TRUE &amp;&amp; [conv_Unagreed] == TRUE) ([conv_Status] == 15) ELSE ([conv_Status] == [conv_Status])
  </code></pre>
  <p>And the Error message is as below:</p>
  <blockquote>
  <p>Error at tblDetail [Derived Column [143]]: Attempt to parse the expression &quot;If( [conv_Status] ==10 &amp; [conv_Agreed] == TRUE &amp; [conv_Unagreed] == TRUE) ([conv_Status] == 15) ELSE([conv_Status] == [conv_Status])&quot; failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis.</p>
  <p>Error at tblDetail [Derived Column [143]]: Cannot parse the expression &quot;If( [conv_Status] ==10 &amp; [conv_Agreed] == TRUE &amp; [conv_Unagreed] == TRUE) ([conv_Status] == 15) ELSE([conv_Status] == [conv_Status])&quot;. The expression was not valid, or there is an out-of-memory error.</p>
  <p>Error at tblDetail [Derived Column [143]]: The expression &quot;If( [conv_Status] ==10 &amp; [conv_Agreed] == TRUE &amp; [conv_Unagreed] == TRUE) ([conv_Status] == 15) ELSE([conv_Status] == [conv_Status])&quot; on &quot;Derived Column.Inputs[Derived Column Input].Columns[conv_Status]&quot; is not valid.</p>
  <p>Error at tblDetail [Derived Column [143]]: Failed to set property &quot;Expression&quot; on &quot;Derived Column.Inputs[Derived Column Input].Columns[conv_Status]&quot;.</p>
  </blockquote>
  <p>Thank you</p>