January 6, 2006 at 12:28 pm
while importing and access database to sql server.Two errors are encountered
1)Insert error column 17(service_date , dbtype_dbtimestamp) status 6 data overflow invalid character value for cast specification.The data type is access is Date/Time and the value in sql server is datetime.The values in access look like 10/12/2005
2)There is also a violation of primary key on a table in sql server where the primary key contains a date and a time both represented by datetime and in sql server they are represented by Date/time Date/Time but no two fields have been found to be the same
Your input is appreciated...
Mike
January 6, 2006 at 12:39 pm
Oh the beloved datetime thing.
9/10 times it has something to do with the server being configured to recognise dates in month-day rather than day-month or vice verse.
I got so teed off with the date time issue that I deliberately imported the Access tables into an intermediate table and then had a step that reformatted the intermediate table into the final destination table.
There is probably a much better way of doing this. Another alternative is to use a data transformation via an ActiveX script however you may find that a little long winded.
January 10, 2006 at 9:03 am
Thanks for the responses
I found a date not between 1753 and 9999 (203 which sql server assumed to be 20203) and there were was violation of the primary key.
That is exactly what the error message said
Mike
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply