Problem while loading sqlserver table using parallel extende

snt_ds · Post by **snt_ds** » 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

snt_ds · Post by **snt_ds** » Thu Jan 29, 2009 4:03 am

Any body please help me

ray.wurlod · Post by **ray.wurlod** » 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.

DSguru2B · Post by **DSguru2B** » 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.

sunithakona · Post by **sunithakona** » Mon Feb 02, 2009 11:44 am

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