Hi

I have a few questions on DTS packages!

1. Scheduling DTS Job - Security

If i need to schedule the dts job as a non System administrator login,
i need to create a sql agent proxy acnt. All permissions for the
package will be the proxy acnt permissions. Is this correct? Any
warnings here?


2. Passing Password to DTS Job - DTSRUN

I want to dynamically set the password from some external source for
DTS connections. I can use UDL files - but it stores plain text
password. (Which is not secure).

I did some google and found out that DTSRUN supports launching of
packages and with switches for global parameters and encrypted
password provision! There is a utility DTSRUNUI. Can i use this to
schedule and pass sql server login and password to package level
global variable?

And will this affect the previous question?

Thanks!

1 Correct. Make sure the account has only those permissions it requires.
2. DTSRUNUI is there to help you construct the DTSRUN command. It takes
your inputs and builds the string necessary.

The preferred method of communication between resources is a Trusted
connection.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Karthik R" <dtsguy1 (AT) rediffmail (DOT) com> wrote

Thanks very much Allan.

Karthik

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote