SQL Server Performance Forum – Threads Archive

DBTYPE_DBTIMESTAMP

Hi Gurus, When i was moving data from one sql server to another by DTS. I got error at destination table like dbtype_dbtimestamp at Row no.13497. please help me to fix the error Thanks in advance Regards lkarthik

Can you type the whole error here
what are your cource and destination databases , both are SQL Server??
check the source and destination datetime columns

Sounds like that value can’t be transformed into a valid datatime value. Are the regional settings on both servers the same? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>