If you want to create a cplumn that has more than 255 characters, you can use TEXT as its datatype (not sure if it works for more that 8000 Characters).

For eg. While creating Table in Execute SQL Task, you code looks somewhat like this:

Create Table 'Table Name' {

'Column1' Varchar(80),

'Column2' TEXT

}

When you are writing this column to Excel File, you need to use a Data Converstion Task inside Data Flow Task and change the column type to Unicode Text Stream