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 |
|
ramone_johnny
Starting Member
35 Posts |
 Posted - 2003-11-02 : 21:37:12
|
| I have just imported an access database across to SQL server and have recieved the following error... "Error at Destination for Row Number 1. Errors encountered so far in this task: 1. Insert Error, column 11 ("time_registered' DBTYPE_DB_TIMESTAMP), status 6: Data overflow. Invalid character value for cast specification." The column mentioned is a simple general long date as far as I can see. Here are the details.... *time_registered* Format - General Date Input Mask - Caption - Default Value - Time() Validation Rule - Validation Text - Required - No Indexed - No IME Mode - No Control IME Sentence Mode - None Also, I have noticed that many of my fields have a maxlength of '4'. Why is this and how can I change them back? Thanks guys, JohnComplete newbie. Please forgive me for having to ask such stupid questions... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-02 : 22:32:06
|
| >> Also, I have noticed that many of my fields have a maxlength of '4'Are they text or char/varchar? If text then 4 is the length of the pointer not the data. You should change them to varchar with the correct size.It is easier to import into a table with all character fields then you can move the data to the final table and perform any conversions along the way.You can convert datetime to yyyymmdd hh:mm:ss with a source query - this will be accepted into a datetime field.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ramone_johnny
Starting Member
35 Posts |
Posted - 2003-11-02 : 23:06:12
|
| Thanks nr,Im completely new at this so no doubt there'll be additional questions of such nature. I think the mentioned fields are navchar or something....not sure.I would have stuck with access but Im assuming sql server will have long term benefits. Especially when the application is within larger type environments.Regards,JohnComplete newbie. Please forgive me for having to ask such stupid questions... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-03 : 02:16:45
|
| nvarchar - a unicode character string. In that case you should worry that the lengths are 4.If you don't need unicode then change them to varchar and make them the correct size.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Import Error - Datatype issue or something else?