For operands of the conditional operator, the data type DT_STR is supported only for input columns and cast operations. The ...

For operands of the conditional operator, the data type DT_STR is supported only for input columns and cast operations. The expression "%1!s!" has a DT_STR operand that is not an input column or the result of a cast, and cannot be used with the conditional operation. To perform this operation, the operand needs to be explicitly cast with a cast operator.