output string to text file hits 255 char limit

[voxinforma]

I have a DTS which runs a query that concatenates some varchar fields and exports results to a text file. The query runs fine alone and returns records no matter what the length, but the text file seems to truncate each record after 255 chars. Is there a way to address this?

 

[mutley1]

Sorry - not sure if this is going to solve or not, but was looking on Technet for something and stubled on this. Might be worth a look.

http://support.microsoft.com/default.aspx?scid=kb;en-us;247527

 

[voxinforma]

thanks for the link. I will probably change the export file type to xls, as that seems to work fine without any truncation.