Hi out there,

I have a simple DTS package that copies data from a SQL7 into SQL2000.
Source and destination column are one2one mapped, one column is of text type.
When I execute the package the text colum in the destination table doesn't
contain any all data in source. There is no error thrown...
When I add a #temp table where I first select into the field from there
perform the a DTS to destination then the text filed is completely field.

What can I do to avoid this extra processing, in one step task?
Thx..