thanks Mak,
I tried to execute your dts from 2 servers
same result , string truncated...
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
For this reason, I use bcp (bulk copy program) for my text file exports unless I know for a fact that every field is less than 255 and always will be. The downside of using bcp is that it doesn't export the column headers. I use DOS scripting to get around that.
There are other alternatives listed at the bottom of the KB article.