Friday, March 9, 2012

Error converting data type DBTYPE_DBTIMESTAMP to datetime

Hi

I am trying to migrate data from oracle to sql server 2005 in sql server management studio express, most of my data in oracle have been successfully moved into sql server 2005 by using storage procedure. But some of data can't move across becasue i got this error:

Error converting data type DBTYPE_DBTIMESTAMP to datetime

Does anyone know why? Please help?

Thanks

Li

There is "invalid" datetime data in one of the columns, thi could be based on a out-of-range value or another date representation which does not fit the destination one. If you cannot identitfy the values which cannot be imported, try to import the data to SQL Server using a VARCHAR or CHAR destination data type and find out which values are malicious using the ISDATE Function.

HTH, jens K. Suessmeyer.


http://www.sqlserver2005.de

No comments:

Post a Comment