Text column transform - between column of the same type
-------------------------------------------------------

Trying to transform a text column from one table into a
another table of the same type.
I have DTS packages defined to perform the copy column.
The DTS package fails on the step where the
text value gets assigned to the destination column. When
I test the copy column I get the following error
'Data for source column 21 is too large for the specified
buffer size.' however when I run the package
the error in the log file is different and as listed below.

Currently we are not able to increase the buffer size to
be greater than 9999. Is there a way we can let SQL
Server handle the buffer size.

Any help in this regard is appreciated.



Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:String data, length mismatch
Error Help File:
Error Help Context ID:0


Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:[DBNETLIB][ConnectionWrite (send()).]
General network error. Check your network documentation.
Error Help File: