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)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.....