import data from MS Access databases to SQL Server 2000 using the DTS Import/Export

I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors.

Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.

Could you please look into this and guide me
Thanks in advance
venkatesh
imtesh@gmail.com

What's source and target data types of those columns? What are values in those columns?

Both the source and destinations data types are Date/Time.
Sql server cannot able to accept this data type fromt MS-Access. I think Sql server 2000 service pack 4 is the best solution for this issue.. Whats your opinion.. Could you please guide me in this issue..
Thanks
Venkatesh
imtesh@gmail.com

Change the
Destination Datatype of (VRptTime, ViewMentalTime, ViewAppTime,Time) SmallDateTime
in to DateTime

1 ) In the Select Source Dialog Box,
Select the Transform Button.


2) Then You get Column Mapping & Transfermations Dialog Box.

3) In that Dialog Box - Column Mapping Tab

If u select [Create Destination Table] option and Drop and Recreate Option..

Then Only you Change the Destination Datatype in Type Column.

yeah thanks i fixed...