MS SQL Server DTS - Security Question

Author

Security Question

Liz

2006-01-23, 1:23 pm

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

Allan Mitchell

2006-01-23, 8:24 pm

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

> 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
>

Sponsored Links