My source oracle 7 and target SQL, when I run a job it trows me an error after running 77,000 record which is fatal error type
there are two date fields but if the problem is with date time, it should abort first only, its aborting after running 77000, and date fields are yyyy-mm-dd hh:mm:ss format, could some one help
STGRFQ..Transformer_61.Out_USER_INSERT: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO STG_RFQ(RFQID, DateProposedEffective, SalesDeadLineDate, EligibleEmployees, IsLifeQuote, IsDentalQuote, status_ind, RegionKey) VALUES (?,?,?,?,?,?,?,?)
SQLSTATE=22008, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Datetime field overflow