DSXchange

Posted: **Wed Jan 28, 2009 9:47 pm**

Hi,

My Requirement is to laod the data from oracle to sql server using parallel extender.
while loading into sql server table, NextRunDate field having a datatype of datetime is populating with NextRunDate filed from oracle table datatype of timestamp. But records are not loading into sql server table and throwing warning message like "Dateoverflow".

Could any one help me about DateTime datatype in sqlserver?

Thanks in Advance,
snt

Posted: **Thu Jan 29, 2009 4:03 am**

Any body please help me

Posted: **Thu Jan 29, 2009 3:11 pm**

Learn patience.

If someone knows an answer then that someone will post it as and when they can.

Posted: **Thu Jan 29, 2009 10:08 pm**

It has to be the milli/nano seconds. Oracle allows more than 6 while sql server is restricted to 3.

Posted: **Mon Feb 02, 2009 11:44 am**

Try using the character data type in SQL Server load stage.

DSXchange

Problem while loading sqlserver table using parallel extende

Problem while loading sqlserver table using parallel extende