DTS Import error on CkDate

Im trying to import a tbl from access why am i getting this msg?
Error at destination for row #58
Insert error, colm 6 ('Check Date, dbtype_dbtimestamp), status 6: Data over flow.
Invalid character value for cast specification.Please look in Access at row 58 and see what the illegal character is. Use the dts to clean the data as it come in.

Take a look aWarning: Non-existent step referenced by
@.on_success_step_id.
attachment as see what these errors are???

Warning: Non-existent step referenced by @.on_success_step_id.
Warning: Non-existent step referenced by @.on_success_step_id.
Warning: Non-existent step referenced by @.on_success_step_id.
Warning: Non-existent step referenced by @.on_success_step_id.

Thanks|||The data in row 58 for check date is a regular date

I dont understand what your saying about :

Take a look aWarning: Non-existent step referenced by
@.on_success_step_id.

or how to transform data from dts|||Specifically, what do you have set in SQL Server as the datatype for your date/time column?

Can you show us several rows that you're attempting to import, including the one that failed?|||I was trying to use datetime as the colm type. I end up with no rows in my table and all the rows in my access tbl are the same format :

Date_Entered Initials Vendor Name CheckNum Type ChkDate ChkAmt
11/19/02 ns 21' Club Inc. 1083 Meal 10/16/02 1,170.59
11/15/02 ns 21' Club Inc. 1091 Meal 11/12/02 1,634.68|||how are the delimited during your import? Tabs?|||I was just using Dts wizard import from an access database.|||Just a thought.. make a backup of your MDB, pull out all the rows but one and see if it imports ok. Then try this again with the row #58 row and see if it goes through or bombs again.