dbTalk Databases Forums  

DTS Package Global Variable Question

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


Discuss DTS Package Global Variable Question in the microsoft.public.sqlserver.dts forum.



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

Default DTS Package Global Variable Question - 03-11-2005 , 03:30 PM






Is the /A parameter from a DTSRUN command automatically assigned to the
global variable defined in the DTS package? If not, how would this be
done? I'm trying to pass path/filename information to change the
datasource text file, but the global variable that I use to assign to
the datasource appears to be empty.


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS Package Global Variable Question - 03-12-2005 , 12:25 AM






That is the point of the switch yes.

If you run it though and then go back to design time, the value for the
Global Variable will be the one set at design time and not from the
DTSRUN cmd.

Allan

"rupert" <scot_mincey (AT) yahoo (DOT) com> wrote


Quote:
Is the /A parameter from a DTSRUN command automatically assigned to the
global variable defined in the DTS package? If not, how would this be
done? I'm trying to pass path/filename information to change the
datasource text file, but the global variable that I use to assign to
the datasource appears to be empty.


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 - 2013, Jelsoft Enterprises Ltd.