InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 06:55:43 GMT20http://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspxThank you for the feedback Swarren - other people will certainly benefit from it.Fri, 18 Jan 2013 13:41:08 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspxFound the problem! Single line comments ( -- my comment) in the SQL work fine for parsing and previewing, but evidently the 64bit provider strips out CRLF's which makes for bad SQL. Multi-line comments ( /* my comment */ ) are fine.Fri, 18 Jan 2013 12:30:26 GMTswarren 48095http://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspxI'm having the EXACT same problem. The query parses and previews fine in BIDS, but when I run/debug the package, I get the "missing expression" error. Wrapping the SQL with BEGIN END just changes my error to "No column information was returned by the SQL command", followed by "Command was not prepared". Any other ideas?Thu, 17 Jan 2013 05:41:14 GMTswarren 48095http://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspxThat was a pretty useful reply to the post!!..Wed, 16 Mar 2011 05:03:42 GMTalexsmth114http://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspx[quote][b]knight.randy (1/27/2011)[/b][hr]Try wrapping your Oracle statement in BEGIN END. This will pass it off to the PL/SQL parser. I have had success doing this with a variety of strange issues like this.[/quote]Agreed - this may solve the issue.Suggestion converts original SQL statement into a PL/SQL block - remember, on the Oracle world SQL and PL/SQL are not the same, different syntax, different set of instructions, different rules.Fri, 28 Jan 2011 08:48:08 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspxTry wrapping your Oracle statement in BEGIN END. This will pass it off to the PL/SQL parser. I have had success doing this with a variety of strange issues like this.Thu, 27 Jan 2011 01:31:09 GMTRandy Knighthttp://www.sqlservercentral.com/Forums/Topic1053539-1044-1.aspxI have been working on migrating three of our old server to a new single instance. The new instance is 2008R2 and I am using the 64bit OraOLEDB.Oracle provider.I have a couple of queries that are used in a DataFlow Task as the source(oracle). Both of these queries will run against the 32bit MS Oracle provider. Using the 64b Oracle provider, I have gotten both to parse, and provide results with the 'Preview'. Both will run in TOAD. Neither is successful when executing the package/task. Both fail with "ORA-00936: missing expression". Has anyone else suffered anything similar. Resolution?I have found that the OraOLEDB.Oracle provider is very particular in what it will accept. Queries that ran fine with the 32b MS Oracle provider must be massaged (or optimized ;-) ) to work.Tue, 25 Jan 2011 14:26:48 GMT_Louie_