Hi all,

When I run a package with dtsrun utility I wanted other users to run it also
and provide the necessary global variable parameters but not be able to view
or edit it.
However, it only works correctly when the owner password is provided in /M.

If I use the user password in /M, the values for the global variables are
not passed.
Encrypting it is no good, since this does not allow the user to provide the
parameter values for the gv's if necessary since these are encrypted also.

This seems to me to be an oversight on MS's part since if the dts package
was run from designer, I could do this, but it seems not from dtsrun.exe.

Any thoughts ?

Regards
PR Williams.

So this is because you are asking to modify the package and only the /Mowner
password can do this.

Set your variables somewhere and have the DTS package read them itself.
(Maybe a DB table?)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"PRW" <PRW (AT) discussions (DOT) microsoft.com> wrote