using SSIS to export long strings

[MDCrab]

hello,

I'm trying to use SQL 2005 Enterprise Manager to create an Excel spreadsheet (or Access db) from the data in my database. I've got tables that have a column that is varchar(6000). When I use SSIS to try to take the data to Access/Excel, I get this message:

"Error DTS.Pipeline: The output column 'comments' has a length that is not valid. The length must be between 0 and 4000."

I can't live with truncating my data. I need to try to get all 6,000 characters out of my tables.

Anyone have an idea as to what to do about this?

thanks.

 

[MDCrab]

I've found a third-party solution to the problem that I described. So, i'm not looking for a reply anymore. Thanks.