Datetime field overflow

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sridhar Sivakoti
Participant
Posts: 35
Joined: Tue Feb 13, 2007 5:30 am

Datetime field overflow

Post 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.
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

Do an exact search on "Datetime field overflow". See if one of those posts help.
Sridhar Sivakoti
Participant
Posts: 35
Joined: Tue Feb 13, 2007 5:30 am

Post 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.
Post Reply