I'm executing DTS from asp with this code and hard coded user pwd in asp
file
it works just fine

Dim objPkg, strError, iCount
Set objPkg = Server.CreateObject("DTS.Package")
const DTSSQLStgFlag_UseTrustedConnection = 256
objPkg.LoadFromSQLServer "server", "",
"",DTSSQLStgFlag_UseTrustedConnection,"blablab la-user-pwd","","","dts_package"
objPkg.Execute()

but when i use globalvariables, package executes but returns error, that i
need owner passwords,

Set objPkg = Server.CreateObject("DTS.Package")
objPkg.LoadFromSQLServer "server", "",
"",DTSSQLStgFlag_UseTrustedConnection,"blablab la-user-pwd","","","dts_package"
objPkg.GlobalVariables("code").Value = Code
objPkg.Execute()
Set objPkg = Nothing

in enterprise manager, dts with global variable runs without problem with
user passwords

i realy don't want to code owners password in asp file, because it runs as
"sa"

is there solution for this?

The owner password is not the sa password. The owner password is a password
that allows you to change and edit the package. A User password allows you
to run the package and not edit it. It has nothing to do with SQL Server
logins.



--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Muson" <muson (AT) muson (DOT) lt> wrote

When creating DTS i created connection, and entered sa login, so t-sql is
executed as sa, for example user from asp can run sp_cmdshell

i don't want to grant everybody sp_cmdshell permissions, so i using dts with
saved sa password in it (in connection properties)

If i created connection with sa, if someone can open this dts, change script
for example, to add him to - system administartors role

i encrypted it, with owners and users passwords...

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