I am running a sql query Concatenating a string with results which should be approx 2000 characters. 255 characters. In results the string is being truncated at 255 char. Am using enterprise manager and dts routine. How can I get acound this 255 limit. I know I can use Query Analyzer (done that) but I need to have this run each night vea DTS. Thoughts??