I'm using DTS to move table structures and data from Access97 to SQL 2000. I continue to get an error that reads "data overflow - invalid character value for cast specifications."

The field is a date field and I have already tried transforming it from shortdate to datetime - this changed nothing. I know that it is field specific and not record specific because there is no data in the record.