Just wanted to post this in case someone else feels my pain.
I've been working with Oracle and SSIS recently, I wrote a delete statement within Developer that worked perfectly, pasted the SQL into an SSIS Execute SQL Task and again
it parsed successfully however once I ran the package it failed with the above error!
After multiple re-writes of the query trying to figure out the Oracle syntax for this delete statement I finally found the following
So credit where its due this saved me hours more work and debugging, apparently you cannot use -- to comment your scripts in SSIS when using Oracle
I hope this helps someone else
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe