>>Hi,
>>
>>When transferring a table that contains a field of varchar(8000) the imported table ends up with no records in it.
>>
>>Is this a result of transferring the large varchar field, or ???
>>
>>Thanks
>>Michael
>
>What is the source and what is the data type?
Varchar

>What type of DTS package are you creating, e.g., field copy?
Transfer objects from one database to another

>What version of SQL Server?
7.0

>With a Varchar 8000 you are most likely bringing it in from a BLOB or other large format. I've run into trouble with BLOBs with DTS especially in 7. I usually convert them to character if the type allows.

???