I have a job which read a file and load it in SQL server table. ODBC stage is used to do this.
Whenever I trying to load a big file it is giving me following error.
Code: Select all
djsLoadGECStagingExp.3611_200709.tfbExp.lnkExpWrite: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO tblExposure(SiteID, PeriodID, ExposureID, BorrowerID, SupporterID, SupportType, ExposureDesc, EffNumLoan, UCurrency, NetCommitment, ExposureAtDefault, LossGivenDefault, LossGivenDefaultPercent, UsgAmount1, UsgAmount2, StartDate, NetAgreementInd, MaturityDate, RecurFee, UpfrontFee, NonUsgFee, UsgFee1, UsgFee2, FixCoupon, PayFrequency, CouponType, PrincipleType, AmortDate, Period, Entity, CustGroup, CustSubGroup1, CustSubGroup2, SecuritizationFlag, BaselPortfolioFlag) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Serv
I searched the forum a lot, but no one seems to have faced such issue.
This was working fine earlier with 200 array size.
Any inputs or suggestion?