DSXchange

Hi,
I am getting this err:
Load_IPNA_Sample_insert..Transformer_36: [DataDirect][ODBC SQL Server Driver]Datetime field overflow.

Please explain what might have caused it.....I checked several times but unable to figure....especially when more that half of the records got inserted with the same kind data....(I got two timestamp fields, one from the source and the other I have hardcoded some default value)

Thanks
Arnie.

Check the records that did not get inserted, see what the timestamps look like on those records. Use a reject link to capture them if need be, write the timestamp to a varchar there.

Thanks for the reply....

what I observed is very starnge...

2008-09-04 07:57:00.00 is getting converted to 2008-09-04 07:57:00.000000......althougt there were no transformations involved...just straight moved in the transformer.....

Thanks
Arnie

SQL Server includes milliseconds from what little I know. What is the actual target data type for that field in the table itself?

data type is Timestamp 23,3......

any way to remove the millisecs....?? But the target is seq file here (intermediate job),so I guess the millisecs getting added in the transformer...

You should be able to match that in the job, I believe, that or trim off the 'extra' milliseconds. 2008-09-04 07:57:00.000 would not overflow.