Re: How to call Oracle package from DTS package?

From: Kris (KrisTomczak_at_msn.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 12:12:48 +0100

I can execute any Select statement successfully , but I don't know how to
call a package.
I'm getting an error: Invalid SQL statement.

My call looks like:
customer.customer_load('test', 11)

I've tried:
customer.customer_load('test', 11)
call customer.customer_load('test', 11)
exec customer.customer_load('test', 11)
execute customer.customer_load('test', 11)

with the same result.

Cheers,

Kris

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23pKBF8JREHA.3016@tk2msftngp13.phx.gbl...
> Can you not do this from within the ExecuteSQL task whilst pointing the
> Oracle connection?
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Kris" <KrisTomczak@msn.com> wrote in message
> news:O0V5IiJREHA.3452@TK2MSFTNGP10.phx.gbl...
> > Hi All,
> >
> > I'm designing DTS package on SQL Server and need to call/execute Oracle
> > package (stored in an Oracle database).
> > How to call an Oracle package from DTS?
> >
> > Cheers,
> >
> > Kris
> >
> >
>
>

Relevant Pages

  • Nested packages not firing events when executed via .NET interop
    ... This works fine on individual packages, but when I execute a package ... void PackageEvents.OnError(string EventSource, int ErrorCode, ...
    (microsoft.public.sqlserver.dts)
  • Re: Using Python in ActiveX task - works when run as separate step
    ... when executing the package. ... Peter Yang, if you can detail some of what you did to get Perl working, I'd ... >> was trying to use Python in this case because I know it a little better than ... >>>You could execute the step in DTS package window. ...
    (microsoft.public.sqlserver.dts)
  • Re: alter index (Oracle Text index) rebuild on different schema => no rights
    ... I put the "alter index" statement in a stored procedure and put it in ... The execution of the package has to ... Execute it dynamically as a workaround. ... REBUILD statement without proper PARAMETERS clause (which ...
    (comp.databases.oracle.misc)
  • Not all steps in DTS package execute
    ... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Package: symbol reading woes
    ... package hasn't been loaded at read time." ... Maybe I'll need to settle for eval? ... it looks to me (I didn't execute your code and don't ... maybe you can just load the library. ...
    (comp.lang.lisp)