dbTalk Databases Forums  

Executing Oracle stored procedures from DTS task

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Executing Oracle stored procedures from DTS task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Executing Oracle stored procedures from DTS task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Javier
 
Posts: n/a

Default Executing Oracle stored procedures from DTS task - 09-16-2003 , 11:10 AM





Hi

I need to know how can I exec oracle sp from a DTS task

I tried using "Execute SQL Task" but It said that "Procedures, functions ,
packages are not allowed"

Thanks in advance

jvillegas (AT) impsat (DOT) com.ar



Reply With Quote
  #2  
Old   
Nick Schueler MS
 
Posts: n/a

Default RE: Executing Oracle stored procedures from DTS task - 09-30-2003 , 03:40 PM





Hi Javier
There is not a built-in way for DTS to execute a Oracle stored procedure.

You might try Execute Process Task. If you can create a batch file that
executes an Oracle's command line query tool and submit the procedure call.

This batch file could be run within Execute Process Task. Remember you will
need the Oracle tools on the system where the DTS Package is run.

Nick Schueler



--------------------
Quote:
From: "Javier" <mask (AT) impsat1 (DOT) com.ar
Subject: Executing Oracle stored procedures from DTS task
Date: Tue, 16 Sep 2003 13:10:49 -0300
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <urB#c0GfDHA.2320 (AT) TK2MSFTNGP12 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: 200.0.195.143
Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!cpmsftng xa06.phx.gbl!TK2MSFTNGP08.
phx.gbl!TK2MSFTNGP12.phx.gbl
Quote:
Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.dts:38598
X-Tomcat-NG: microsoft.public.sqlserver.dts

Hi

I need to know how can I exec oracle sp from a DTS task

I tried using "Execute SQL Task" but It said that "Procedures, functions ,
packages are not allowed"

Thanks in advance

jvillegas (AT) impsat (DOT) com.ar
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top