DTSRUN password and username

Hello,
I run DTSRUN command in SP on many copmuters.
No problem with local server parameter but how can i use constant of the /U and /P parameters not to write username and password every time. could this be taken from the local server itself?
Thx
InonliYou can use /E to use integrated security.|||Originally posted by nigelrivett
You can use /E to use integrated security.

thank you very much
and maybe you know this
i have active x script inside the DTS that do
cnADODB.Open "Driver={SQL Server};Server=212.179.64.215;UserName=sa;Password =Ropin1970;Database=SoftAd"
i want to change the ip to local but it not let me
any idea?|||Have you tried Server=(local)

I usually put the server in a glabal variable and use that in the script.
If you are loading from an SP then you can use dtsrun to set it to @.@.servername.

Thanks for your sa password :).|||Originally posted by nigelrivett
Have you tried Server=(local)

I usually put the server in a glabal variable and use that in the script.
If you are loading from an SP then you can use dtsrun to set it to @.@.servername.

Thanks for your sa password :).
not working with server = (local)
the problem with global variable that i use many servers (by the way they have other passwords for sa...) and cant run it with /A as have mssql97... not 2000|||In that case see
http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html

To load the package and set global variables before running.|||Originally posted by nigelrivett
In that case see
http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html

To load the package and set global variables before running.

thank you a lot this will help me also in other thing!