1 Reply Latest reply: May 20, 2013 5:22 PM by Ayush Ganeriwal-Oracle RSS

    ODI-1228: Task SrcSet0 (Loading) fails on the target MICROSOFT_EXCEL connec

    988501
      Hi

      i am trying to exporting the database table data into excel sheet i am getting the below error.




      ODI-1228: Task SrcSet0 (Loading) fails on the target MICROSOFT_EXCEL connection Ms_EXCE_TGT.
      Caused By: java.sql.SQLException: [Microsoft][ODBC Excel Driver] 'C$_0Location' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.


      Code:

      create table "C$_0Location"
      (
           C1_POSITION_DEFINITION_ID     VARCHAR(255) ,
           C2_SUMMARY_FLAG__________     VARCHAR(255) ,
           C3_ENABLED_FLAG__________     VARCHAR(255)
      )

      Edited by: 985498 on May 15, 2013 4:06 AM