Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ORA-00936 Missing Expression With SSIS Execute Script Task Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 9:12 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 21, 2016 8:42 AM
Points: 698, Visits: 3,018
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
Post #1417163
Posted Friday, February 8, 2013 8:54 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1417758
Posted Monday, August 17, 2015 2:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 17, 2015 2:14 PM
Points: 5, Visits: 28
You save my day bro!!! Thanks
Post #1712413
Posted Tuesday, August 18, 2015 1:31 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 21, 2016 8:42 AM
Points: 698, Visits: 3,018
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
Post #1712482
Posted Friday, September 30, 2016 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 7:42 AM
Points: 1, Visits: 30
You saved me with your observation on "--" for commenting. Thanks. Who would have thought?
Post #1822410
Posted Friday, September 30, 2016 7:35 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 21, 2016 8:42 AM
Points: 698, Visits: 3,018
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
Post #1822419
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse