You can use the dynamic properties task to set the values
for the global variables. The source for the values in the
dynamic properties task can be a query.
-Sue
On Tue, 9 May 2006 09:33:02 -0700, Carl Henthorn
<CarlHenthorn (AT) discussions (DOT) microsoft.com> wrote:
Quote:
I have inherited a large number of DTS packages that have db logins/passwords
hard coded in the global variables section. I want to change these to have
the login/password stored in a central parameter table and have the packages
look them up when they run. Is there a way to do this in Sql 2k? or any other
method?
thanks!!
|
dynamically set global variables -
05-09-2006
, 11:33 AM
Linear Mode
