ETL and Data Integration tools - Modern ETL software for everyone

Hello,

I'm having some trouble with a job I recently created. The source is a FOX PRO DB.
Target is a MySQL DB. For the source I'm using a Select statement:

Select * from drugndc Where (DLastPriceUpd> (Date() - 91))

Now, it appears that updates are occurring. However, looking at
"Transformation Log", looks like I getting lots of errors. Please advise.
Attached is the log for review.

PS> as suggested before, I have "SET AUTOCOMMIT=0;" under "SQL Before" and "COMMIT;" under "SQL After".

Holman

Hello

It is complaining about field PMCUnitCost

#HY000Field 'PMCUnitCost' doesn'PMCUnitCostt have a default value
Information 7/2/2010 11:19:15 AM insert into medsndccost ("NDCNum","DrugIDQualifier","NDCFi","DrugID","DrugManID","DrugNameID","ManuFactID",
"Shape","Color","PackageSize","PkgSizeMedicaid","UnitDoseID","AWPCost","DirectCost","MacCost","WACCost",
"Plan340B","Plan340BCost","SpecialPrice","ProRate","SPriceExp","LastPriceUpdt","VSUpdateDate" )
values (:F1,:F2,:F3,:F4,:F5,:F6,:F7,:F8,:F9,:F11,:F12,:F13,:F14,:F15,:F16,:F18,:F19,:F20,:F21,:F22,:F23,:F24,:F25 )


I guess it is not null field plus you have not mapped it and there is no default value.


ALTER TABLE
medsndccost
MODIFY
PMCUnitCost DATE NOT NULL DEFAULT 'somevalue'


Mike