I am stuck at a similar dilemma with Excel source and Jet provider.

Cannot edit registry key.

I was thinking about this.. but I am not sure if it is possible.. Can I add a dummy row with more than 255 chars each time data flow task runs by using a script task and then take the dummy row out using an identifier?

Script Task (add dummy row, move all rows one level below dummy)

Excel Source

Some other Task (which you would normally go to and take dummy row out)

I have near zero scripting skills and am looking for help to see if this is a possibility