February 7, 2013 at 9:12 am
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
http://thefirstsql.com/2012/09/28/ora-00936/
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
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 8, 2013 at 8:54 am
Thank you for the posting Andy. I'm sure it will help a number of people down the road, Thank you for sharing.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 17, 2015 at 2:14 pm
You save my day bro!!! Thanks
August 18, 2015 at 1:31 am
Glad it helped 😀
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 30, 2016 at 7:19 am
You saved me with your observation on "--" for commenting. Thanks. Who would have thought?
September 30, 2016 at 7:35 am
Glad its helping people 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply