dbTalk Databases Forums  

passing vars to dts

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


Discuss passing vars to dts in the microsoft.public.sqlserver.dts forum.



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

Default passing vars to dts - 12-13-2004 , 04:00 PM






hi all!

is it possible to pass a variable to dts that is not a global var?
if yes, can you please inform me how is this done.

many thanks

mirza i


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.811 / Virus Database: 552 - Release Date: 13/12/2004



Reply With Quote
  #2  
Old   
Ilya Margolin
 
Posts: n/a

Default Re: passing vars to dts - 12-16-2004 , 07:34 AM






mirza i,

Is there other kind of variables in DTS? Can you be more specific?

Ilya

"mirza i" <usmirza (AT) hotmail (DOT) com> wrote

Quote:
hi all!

is it possible to pass a variable to dts that is not a global var?
if yes, can you please inform me how is this done.

many thanks

mirza i


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.811 / Virus Database: 552 - Release Date: 13/12/2004





Reply With Quote
  #3  
Old   
mirza i
 
Posts: n/a

Default Re: passing vars to dts - 12-16-2004 , 07:56 AM



well i think that only global vars can be passed from asp and vb into dts
but i was hoping that perhaps normal vars can also be passed in...


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote

Quote:
mirza i,

Is there other kind of variables in DTS? Can you be more specific?

Ilya

"mirza i" <usmirza (AT) hotmail (DOT) com> wrote in message
news:OWbiq8V4EHA.4092 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
hi all!

is it possible to pass a variable to dts that is not a global var?
if yes, can you please inform me how is this done.

many thanks

mirza i


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.811 / Virus Database: 552 - Release Date: 13/12/2004





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.817 / Virus Database: 555 - Release Date: 15/12/2004




Reply With Quote
  #4  
Old   
Ilya Margolin
 
Posts: n/a

Default Re: passing vars to dts - 12-17-2004 , 10:25 AM



mirza i,

There are only global variables for task/step communication in DTS. If you
mean variables in ActiveX scripts, you can pass values to/from them using
global variables.

Ilya

"mirza i" <usmirza (AT) hotmail (DOT) com> wrote

Quote:
well i think that only global vars can be passed from asp and vb into dts
but i was hoping that perhaps normal vars can also be passed in...


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote in message
news:uQQLRO34EHA.208 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
mirza i,

Is there other kind of variables in DTS? Can you be more specific?

Ilya

"mirza i" <usmirza (AT) hotmail (DOT) com> wrote in message
news:OWbiq8V4EHA.4092 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
hi all!

is it possible to pass a variable to dts that is not a global var?
if yes, can you please inform me how is this done.

many thanks

mirza i


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.811 / Virus Database: 552 - Release Date: 13/12/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.817 / Virus Database: 555 - Release Date: 15/12/2004





Reply With Quote
  #5  
Old   
mirza i
 
Posts: n/a

Default Re: passing vars to dts - 12-17-2004 , 03:29 PM



many thanks ilya



"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote

Quote:
mirza i,

There are only global variables for task/step communication in DTS. If you
mean variables in ActiveX scripts, you can pass values to/from them using
global variables.

Ilya

"mirza i" <usmirza (AT) hotmail (DOT) com> wrote in message
news:e%23OdNc34EHA.2804 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
well i think that only global vars can be passed from asp and vb into dts
but i was hoping that perhaps normal vars can also be passed in...


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote in message
news:uQQLRO34EHA.208 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
mirza i,

Is there other kind of variables in DTS? Can you be more specific?

Ilya

"mirza i" <usmirza (AT) hotmail (DOT) com> wrote in message
news:OWbiq8V4EHA.4092 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
hi all!

is it possible to pass a variable to dts that is not a global var?
if yes, can you please inform me how is this done.

many thanks

mirza i


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.811 / Virus Database: 552 - Release Date: 13/12/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.817 / Virus Database: 555 - Release Date: 15/12/2004





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.818 / Virus Database: 556 - Release Date: 17/12/2004




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.