Re: Execute SQL problem with Oracle

From: Elmer Miller (millere_at_empireco.nospam)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 09:22:43 -0500

One more thing: The 'Transform Data' task also works on the same Oracle
connection. What is unique about an 'Execute SQL' task that causes the
'Multiple-step OLE DB operation generated errors' error?

"Elmer Miller" <millere@empireco.nospam> wrote in message
news:ugOi241$EHA.2076@TK2MSFTNGP15.phx.gbl...
>I have a strange problem that I am having trouble troubleshooting. I need
>to execute a SQL commend against an Oracle database using DTS. I created a
>'Microsoft ODBC Driver for Oracle' connection and based an 'Execute SQL'
>task on that connection. When executing the task I get the "Multiple-step
>OLE DB operation generated errors" message. The strange thing is that if I
>go into properties of the Execute SQL task and click 'Build Query', I can
>execute the query just fine in the query builder. Do you have any
>suggestions on how I can troubleshoot this problem? Why does the query
>builder work but the Execute SQL task doesn't. PS I also tried the
>'Microsoft OLE DB Provider for Oracle' with the same results.
> Any help would be appreciated. Thanks.
>

Relevant Pages

  • Re: Execute SQL problem with Oracle
    ... Apparently Oracle connection doesn't ... The 'Transform Data' task also works on the same Oracle ... What is unique about an 'Execute SQL' task that causes the ... >>go into properties of the Execute SQL task and click 'Build Query', ...
    (microsoft.public.sqlserver.dts)
  • Error in New Query Wizard in Server Explorer using OLEDB provider
    ... Whenever I try to create a query involving an outer join and execute SQL with ... Recno integer, Type integer. ... Microsoft OLE DB Provider for Visual FoxPro ...
    (microsoft.public.vsnet.ide)
  • RE: help on a query with parameters
    ... I need to pass a parametert to a query, ... Parameterized queries are SQL queries written for reusability. ... All the tasks above can execute SQL queries written with parameters if the ... task can use only global variables as input to its parameterized queries. ...
    (microsoft.public.sqlserver.programming)
  • Re: Build Query From Data Transformation Task: Update from a Join?
    ... to do the ETL process with as fewer Execute SQL Tasks as possible. ... from a join" query, but it also would contain "select from select" queries. ... >> On using the Build Query option from the Data Transformation task, ...
    (microsoft.public.sqlserver.dts)
  • Re: use of xp_cmdshell
    ... osql and bcp have option to send query result to file... ... "anonymus" wrote in message ... > I want to use xp_cmdshell to execute sql script and send the results to a ...
    (microsoft.public.sqlserver.programming)