I think that this is bugs... step1. plz, create table CREATE TABLE ZZ$BUG ( START_DATE VARCHAR2(8 BYTE) ) step2. create new job step3. Drop the following components from the Palette onto the design workspace : tOracleInput, tOracleOutput step4. Connect tOracleInput to tOracleOutput using a Row Main link. step5. In the design workspace, select tOracleInput and click the Component tab to define its basic settings. and in the Query field, input this sql -- sql " SELECT TO_CHAR(TO_DATE(START_DATE,'YYYYMMDD')-1,'YYYYMMDD') FROM ZZ$BUG " then, you can see. "warning : schema is different from the query" of course, if Press F6 then execute it and this job result is success. just, i see "the waring icon!! " is it bugs?? how is it fixed??
... View more