dbTalk Databases Forums  

Passing DTS Global Variables to/from C# program

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


Discuss Passing DTS Global Variables to/from C# program in the microsoft.public.sqlserver.dts forum.



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

Default Passing DTS Global Variables to/from C# program - 07-01-2004 , 03:31 PM






What is the simplest way to get and set the DTS global
variables from a C# program? I have seen some sample code
but it seems to indicate that you are actually changing
the global vars before executing the DTS. I am interested
in creating a DTS step consisting of a C# console program.
All I want to do is to be able to access the current
(running) values of the global vars and possibly change
them as well. I don't need to be fancy with Custom Tasks
or anything. I am an intermediate C# programmer.


Reply With Quote
  #2  
Old   
Ozone
 
Posts: n/a

Default Re: Passing DTS Global Variables to/from C# program - 07-07-2004 , 07:56 PM






What you can do is use a dynamic properties task to update the values during
runtime. This works well to use values retrieved from an external source
that may change between runs...

HTH
Ozone
"Count Darling" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
What is the simplest way to get and set the DTS global
variables from a C# program? I have seen some sample code
but it seems to indicate that you are actually changing
the global vars before executing the DTS. I am interested
in creating a DTS step consisting of a C# console program.
All I want to do is to be able to access the current
(running) values of the global vars and possibly change
them as well. I don't need to be fancy with Custom Tasks
or anything. I am an intermediate C# programmer.




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.