Okay
Forgive me if someone else has come across this. I couldn't find anything in the forum.
The scenario is that I'm running an Execute SQL Task connecting to an Oracle 11.2 database in Bids. The task runs but performs no activity. The code being executed, (anonymous sql) successfully works on the same database in SQL Developer (with inserts).
Turned out, I think, to be the method of commenting within the Oracle PL/SQL. This was using the single line comment indicator "--".
When I removed some comments, and executed the task the Task failed with.....
ORA-06550: line 1, column 5555:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
The amended code still worked in SQL Developer.
I then amended the relevant comments to use the block comment ( /* and */) and the task successfully executed performing the required inserts.
Hope this helps.
Regards