ORA-00936 Missing Expression With SSIS Execute Script Task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » ORA-00936 Missing Expression With SSIS...

ORA-00936 Missing Expression With SSIS Execute Script Task

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Hyslop

Posted Thursday, February 07, 2013 9:12 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 595, Visits: 2,143

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

PaulB-TheOneAndOnly

Posted Friday, February 08, 2013 8:54 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:00 PM
Points: 2,988, Visits: 4,412

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

« Prev Topic | Next Topic »

Permissions