dbTalk Databases Forums  

Global Parameter for ORACLE Import

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


Discuss Global Parameter for ORACLE Import in the microsoft.public.sqlserver.dts forum.



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

Default Global Parameter for ORACLE Import - 06-21-2004 , 02:57 AM






Hi

I have build a DTS Package with about 35 Tasks, now I would like to
substitute a Value for the Import Query which selects the Sysdate with
a global Parameter, so that I don't need to go altering each one of
them one by one.

....
HAVING MAX(RS.RELEASE)
IN trunc(SYSDATE - ?))
....

Upnon calling the Parameter Button to configure the Variable it says :
'SetParameterInfo is not being called..' or so ..

I am using Oracle Provider for OLE DB..

Can anybody tell me what I am doing wrong, I think it should be
possible..

Any Help is appreciated

Sascha Gazikalovic

Reply With Quote
Reply




Thread Tools
Display Modes

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.