• You can do it in the derived column transformation using the syntax (DT_I4)[Your Column] in the expression field (for a four-byte signed integer).

    Life: it twists and turns like a twisty turny thing