Very Computer

When I use DTS to copy tables from one SQL 2000 database to another database
on the same server (or even another sql Server) sql changes all varchar
fields to Text 16. I am running sql server 2000 with the latest SP and using
DTS - Export data or Import data function fromt he tools menu.
Is there anyway to copy the tables so that all fields remain as they are in
the original table?

Thanks
Kim

Hi Kim

I have tried this here with a SQL Server 2000, SP3 machine and DTS export
wizard created fields as they were in the source table.  For example, I
used the following script to create my dummy table:

create table testDTS (f1 varchar(10), f2 varchar(16), f3 int)
go
insert into testDTS values ('this is aa', '1234561234123421', 1)

Then from DTS, I chose All Tasks, Export Data.  During the wizard, I
clicked on the ellipse (...) in the Transform column of Select Source
Tables and Views and could see that the data type was varchar.  I completed
the wizard and the data was transferred with the correct field type.  I
tried with longer fields (greater than 255) and the corresponding datatype
remained as varchar.

Is the above a close example to the process you are using?

This posting is provided "AS IS" with no warranties, and confers no rights.

Kind regards
Jan Brown
Microsoft SQL Server Support