I am confused as to how to do the following:


Create master DTS package where I set the Connection for the
servername, db, login and password. (I can do the previous part, but
not the following.) Then assign those values somewhere; ini, etc to be
used by other packages.


A few constraints are;
the password can not be viewable, meaning it can't be seen by opening
the ini file.


Process flow example:
Open master DTS package and set severname, db, login and password
values.
Run DTS package #2, it would then use the values added and stored by
the master DTS package.
Run DTS package #3, it would use the values added and stored by the
master DTS package.


As you can see I just want to set the connection info one time, ensure
it's secure and then use it from other packages.


Any help would be appreciated.


Liz

Hello Liz,


1. Can you not set the values you want in the master package (Personally
I would use a DB table for this)
2. Now you call the child package through code. You can then set all the
properties you want directly.

Instead of #2 you could also use the ExecutePackage task and pass in values
to GVs in the sub package.

Allan