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)
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.
Microsoft SQL Server Support