InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:52:29 GMT20http://www.sqlservercentral.com/Forums/Topic1417163-1042-1.aspxThank you for the posting Andy. I'm sure it will help a number of people down the road, Thank you for sharing.Fri, 08 Feb 2013 08:54:48 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1417163-1042-1.aspxJust 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 againit 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[url]http://thefirstsql.com/2012/09/28/ora-00936/[/url]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 elseAndyThu, 07 Feb 2013 09:12:19 GMTAndy Hyslop