Page 1 of 1
Loading in SQL SERVER
Posted: Wed Jun 23, 2010 7:49 am
by consulting
While loading in to the sql server job got abort with the following erroe
ODBC_Enterprise_23,0: [IBM(DataDirect OEM)][ODBC SQL Server Driver]Datetime field overflow
Posted: Wed Jun 23, 2010 7:54 am
by chulett
And?
An exact search here for that message had
30 matches, are you saying that
none of them helped?
Posted: Wed Jan 05, 2011 10:07 am
by muralidwhds
i am also getting the same datetime overflow error because my source column timestamp value is 0010-12-15 00:00:00.000000
while loading into the SQL Server the overflow happen in datetime column
Target SQL Server column type is datetime default format is YYYY-MM-DD HH:MI:SS.sss.
so kindly suggest on this how can resolve ths.
Posted: Wed Jan 05, 2011 10:41 am
by chulett
Well... the way that was posted
in your own thread on the subject comes to mind.
Posted: Wed Jan 05, 2011 10:48 am
by muralidwhds
Posted: Wed Jan 05, 2011 11:22 am
by chulett
Then make known that need in your post, not here. And when you do, let us know why the suggestion already made there isn't working for you.
Posted: Thu Jan 06, 2011 4:27 am
by muralidwhds
OK Thank You Very much.