Loading in SQL SERVER

consulting · Post by **consulting** » Wed Jun 23, 2010 7:49 am

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

chulett · Post by **chulett** » Wed Jun 23, 2010 7:54 am

And?

An exact search here for that message had 30 matches, are you saying that none of them helped?

muralidwhds · Post by **muralidwhds** » Wed Jan 05, 2011 10:07 am

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.

chulett · Post by **chulett** » Wed Jan 05, 2011 10:41 am

Well... the way that was posted in your own thread on the subject comes to mind.

muralidwhds · Post by **muralidwhds** » Wed Jan 05, 2011 10:48 am

I Need solution on this.

chulett wrote:Well... the way that was posted in your own thread on the subject comes to mind.

chulett · Post by **chulett** » Wed Jan 05, 2011 11:22 am

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.

muralidwhds · Post by **muralidwhds** » Thu Jan 06, 2011 4:27 am

OK Thank You Very much.