I want to give user run dts package via dtsrun utility from command prompt.
What permission i should be add to him?

Thanks in advance

They need to be able to log onto the server (if the package is in MSDB) on
which the package resides ([/E] [/u] [/P]). If you have secured the package
with an owner and username then they need this password also (/M). They
also need to be allowed, if the package is in MSDB, to retrieve the package.
By default Guest is a member of msdb so therefore anyone with access to the
server can see inside. If that has been removed then add a user account for
that user to MSDB.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"ton" <barameek (AT) inglife (DOT) co.th> wrote