Problems with Execute SQL Task using Oracle Batch Statements

• ss5523

  SSC Veteran

  Points: 225

  More actions

  November 16, 2011 at 7:56 am

  #148826

  I am trying to use the Execute SQL Task to execute a very simple batch against the Oracle database:

  create table tbl1 nologging as select Column1 from tblOracle;

  create table tbl2 nologging as select Column1 from tblOracle;

  create table tbl3 nologging as select Column1 from tblOracle;

  From Oracle if I run this as a "Execute Statement", I get the an ORA-00911:invalid character error when I run "Execute as Script", it runs perfect.

  When I run this in BIDS I get the ORA-00911:invalid character. Can someone tell me how to run SQL commands as an Oracle Script? :crying: