Page 1 of 1

Datetime field overflow

Posted: Thu Oct 04, 2007 3:23 am
by Sridhar Sivakoti
Hi,

I have developed a job with source and targets are SQL Server tables. I am converting some date value columns from Varchar to Date by using StringToTimestamp function in transformer. When I am running this job I am getting below error.

APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver]Datetime field overflow

Please help on this.

Thanks.

Posted: Thu Oct 04, 2007 3:46 am
by Maveric
Do an exact search on "Datetime field overflow". See if one of those posts help.

Posted: Thu Oct 04, 2007 4:01 am
by Sridhar Sivakoti
Maveric wrote:Do an exact search on "Datetime field overflow". See if one of those posts help.
Yes I have done the search, but I did not get the answer.

Thanks.