• Add 2 derived columns and use the expressions

    RIGHT([yearquarter],2 )

    LEFT([yearquarter],4 )

    Just realized there is not left function is SSIS

    better use the substring

    SUBSTRING("2014Q3",5,2)

    SUBSTRING("2014Q3",1,4)