Left() in SSIS derived column

Hi Folks,

There is no Left() in derived column in SSIS and hence use SUBSTRING(<your string>, 1, <num of chars>)