Copying Text column - truncation
---------------------------------

DTS Gurus,

See below - I have copy pasted the text from MSDN which
talks about copying text/ntext columns.
I have a dts pump which transfers data of type text from
one column in one table to another column of type text to
another table. Does the data from the text column
truncated even in the data pump.

What is the best way to get the data moved between the
tables.

Any help in this regard is appreciated.

KS


"The Copy SQL Server Objects task of DTS truncates fields
of type text, ntext, and image if they exceed 8388602
bytes in length. No error messages are displayed by either
DTS Designer or the DTS Import/Export Wizard. These both
indicate the task completed successfully.
The only indication of failure is a log message written to
a log file named <server>.<database>.log, in the Script
File Directory specified on the Copy tab of the Copy SQL
Server Objects Task Properties dialog box. The log message
specifies the table and column, but not the row, where the
truncation occurred. No error records are written to the
DTS error file or to the SQL Server log."