• Not sure if you found an answer to this or not, but if you want a datatype bigger than 255 characters, you use MEMO as your datatype. This maps to DT_NTEXT SSIS datatype.

    Kindest Regards,

    Frank Bazan