DTS to Excel, Destination field size

[ljevans]

I am using DTS to export data from SQL to Excel. I have a large text field that is being truncated at 255 characters. When I look at the Destination field size for the package, I see that the Data Type for all the fields is VarChar and the size is 255. How can I change this so the text is not being truncated?

 

[JayKusch]

You should be able to adjust that value. Are you using the wizard or creating the DTS Export package yourself?

Thanks

J. Kusch

 

[ljevans]

I am creating the package manually. I know how to adjust the size if I am exporting to a text or csv file, but I can't see how to do it if I am exporting to Excel. I may give up and just export to csv.