[Show all top banners]

NIRAVANA75062

More by NIRAVANA75062
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 oracle and sql serer job help
[VIEWED 3420 TIMES]
SAVE! for ease of future access.
Posted on 08-14-08 2:58 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

I have encountered small issue in sql server. any sql server expert out there, please  help.

i have a sql server job from where i have to passparameter into oracle proc. what i did is
i created dts pkg called "my_dts_pkg and used that oracle proc in there.
now, how do i pass parameter value from my sql server job to oracle proc in my dts pkg..

here is my script used in dts pkg

DECLARE
  V_JOBNAME VARCHAR2(20)   ;
  V_FLAG    VARCHAR2(10) ;

BEGIN

 
  if
  V_FLAG = 'COMPLETE'
 
  then 
 

  ORACLE_COMPLETE_JOB ( V_JOBNAME );
 
  end if;
 
 
  if
  V_FLAG = 'FAILED'
  then
 
 
 
ORACLE_FAILED_JOB ( V_JOBNAME );
 
 
 
 
  end if;
  COMMIT;
END;




My sql serer job setp from where i am calling above dts pkg


 DTSRun /S "(local)" /N "my_dts_pkg" /A "V_JOBNAME":"8"="ok" /A "V_FLAG":"8"="COMPLETE" /W "0" /E



here is my problem. I am not able to pass this parameter from my sql server job to my_dts_pkg.

is there anybody out there who has done this.

any help is appreciated.
Last edited: 14-Aug-08 02:58 PM
Last edited: 14-Aug-08 03:06 PM

 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 365 days
Recommended Popular Threads Controvertial Threads
शीर्षक जे पनि हुन सक्छ।
NRN card pros and cons?
TPS Re-registration case still pending ..
What are your first memories of when Nepal Television Began?
Anybody gotten the TPS EAD extension alert notice (i797) thing? online or via post?
TPS Re-registration
Democrats are so sure Trump will win
Basnet or Basnyat ??
TPS EAD auto extended to June 2025 or just TPS?
nrn citizenship
Toilet paper or water?
Sajha has turned into MAGATs nest
Nas and The Bokas: Coming to a Night Club near you
ढ्याउ गर्दा दसैँको खसी गनाउच
Mamta kafle bhatt is still missing
ChatSansar.com Naya Nepal Chat
whats wrong living with your parents ?
डीभी परेन भने खुसि हुनु होस् ! अमेरिकामाधेरै का श्रीमती अर्कैसँग पोइला गएका छन् !
3 most corrupt politicians in the world
अमेरिकामा बस्ने प्राय जस्तो नेपालीहरु सबै मध्यम बर्गीय अथवा माथि (higher than middle class)
Nas and The Bokas: Coming to a Night Club near you
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters