I found some code to open excel and read contents. I am thinking of testing it out.
Hoping to use a script task to open excel, modify it by sorting by character count on the "255 problem column", and close excel. Then use Excel source.. and it should not truncate, or at least that's the plan.
If you guys have any luck please update.