Hi All,

I use DTs Wizard to import a text file into my MS SQLServer 2000 every
month. This text file contains 236 text fields and it's format never
changes.

The problem that i've found is that the DTS wizard sets each of the
destination fields to varchar (which is fine) but the size to 8000!!!!

I have to go through each one of the fields to reduce the size down to
255 ...... is there any way to change the default field size?

Cheers & Merry Christmas

Dave

Hi

If you click on the transform button you can see the select source tables
and views dialog you can edit the size of the columns in the destination
table.

John


"David Peake" <nospam@nospam.com> wrote in message
news:1103536507.33462.0@despina.uk.clara.net...
> Hi All,
>
> I use DTs Wizard to import a text file into my MS SQLServer 2000 every
> month. This text file contains 236 text fields and it's format never
> changes.
>
> The problem that i've found is that the DTS wizard sets each of the
> destination fields to varchar (which is fine) but the size to 8000!!!!
>
> I have to go through each one of the fields to reduce the size down to
> 255 ...... is there any way to change the default field size?
>
> Cheers & Merry Christmas
>
> Dave