SQL SSIS syntax question
It's what is known in programming as a Ternary Operator. It's common in C/C++, JavaScript and PHP (among other languages).

As tombom states, the idea is that it is a short-hand if statement:

&lt;condition&gt; ? &lt;true-case-code&gt; : &lt;false-case-code&gt;;


SQL Server 2012 and above has it's own Ternary Operator in the form of the IIF statement.

IIF(@type = 2, 1, 0)