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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-06-04 : 10:50:13
|
| Hi Friends ,When i try to copy one table , say for e.g table x from SQL 6.5 to SQL 7.0 it gives me an error that -'Insert Error , column 46 ( 'Coloumn_name ',DBTYPE_DBTIMESTAMP), Status 6 :Data overflow .Invalid character value for cast specification .' This column on the source server ( SQL 6.5 ) has datatype 'datetime ' with value 8 and is NULL .Although there are other columns in this table with datatype as 'datetime' as 8 and NULL , they have been copied successfully to the destination table .Only this specific column is giving an error while copying data .I am using import export wizard to copy data between servers . Since i have no experience with this , would like to have a solution from you to this problem. It will be great help for me .Thank you very much . |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-06-04 : 11:06:31
|
| I've not worked with sql 6.5 much, but your error is that there is a date outside the accepted range for datetime (see BOL for the range).Your options are to find the date(s) and fix them or you can convert them to a varchar field on the transfer.I run into this issue all the time when getting datetime fields from Informix and Oracle. |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-06-04 : 12:24:21
|
| Make sure that your target datatype is datetime and NOT timestamp.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-05 : 02:52:20
|
| The default date*.* field is SMALLdatetime in DTS, if you allow DTS to create the destination table by itself. You need to manually change this to datetime. |
|
|
|
|
|
|
Data Copy Error . Help Required . Urgent Please !