Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2008-03-19 : 11:39:10
|
| Hi,I'm using DTS to transfer data from Access database to SQL Server2000 and SQL Server2005, but both of them were failed.In DTS on SQL Server2000, after run the DTS the error MSG is:DTS Import/Export WizardFailed to copy 1 table(s).Double-click the error row for a detailed description of the error.Double click that error row, I got error MSG:Copy Data from TableXYZ to [NewTesting].[dbo].[TableXYZ] Step---------------------------Error at Destination for Row number 1626. Errors encountered so far in this task: 1. Insert error, column 12 ('DateReceived', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification.So I deleted the record at row 1626 in this testing Access database, changed the data type of the field 'DateReceived' (at Column 12) from smalldatetime to datatime in SQL Server2000. I got the same error as showing above when I run the DTS again.Can anyone tell me why this happens? I don't believe that the DTS Wizard was set wrong step by step.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-20 : 10:20:25
|
| This may be becuse of cahnges made to metadata. Try refreshing the transformations inside the DTS & running again.. |
 |
|
|
lw1990
Yak Posting Veteran
85 Posts |
Posted - 2008-03-20 : 19:53:19
|
| Thanks visakh16,I found the problem, the error message was correct. The column 12 in MS Access has a bad date value in a record, I didn't check it as the table has more than 20k records. After I sort the data by that column, I found the bad value (1/25/256 should be 1/25/2006), corrected it and run again, the job was done.Thank you. |
|
|
|
|
|
|
|
|
DTS error