When importing data from Microsoft Access, DTS automatically uses
smalldatetime for the Access data type datetime.

How can I change this to automatically get datetime to be used for
datetime from Access.

Cheers
Ferdinand

You cannot alter the way AFAIK that DTS determines the datatypes but you
can certainly change the chosen type once DTS has designed the
destination structure.

Allan

"Ferdinand Zaubzer" <ferdinand.zaubzer (AT) schendl (DOT) at> wrote