export to text problem

#1

On SQL Server 2000 sp3, on Windows 2000.

I'm running a simple table-to-textfile DTS job (a single varchar field), and
it's running fine EXCEPT that it won't export the full record. The record
can be as much as 820 characters, but it seems to only want to export a max
of 251 characters. Clearly I'm doing something wrong. Any help would be
much appreciated. TIA.

#2

There is this article here

http://support.microsoft.com/?kbid=247527

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"J O Holloway" <jholloway (AT) pinncorp (DOT) com> wrote

Quote:

On SQL Server 2000 sp3, on Windows 2000.

I'm running a simple table-to-textfile DTS job (a single varchar field),
and
it's running fine EXCEPT that it won't export the full record. The record
can be as much as 820 characters, but it seems to only want to export a
max
of 251 characters. Clearly I'm doing something wrong. Any help would be
much appreciated. TIA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

export to text problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

export to text problem - 08-03-2003 , 06:05 PM

Re: export to text problem - 08-04-2003 , 01:09 AM