I am a new comer. I will ask a stupid question.
How can I set the IIS server account, normally
ISUER_MACHINENAME to have access to load
and execute the package?

Not a stupid question at all. You'd want to start by
referring to the following articles:
Execute a package from Active Server Pages (ASP)
http://www.sqldts.com/default.aspx?207
INF: Execute a SQL Server DTS Package from Active Server
Pages
http://support.microsoft.com/?kbid=252987

If you need this to run under the iuser account, the account
is the same as any other account. By default, the public
role has execute permissions on the dts package stored
procedures in msdb and the guest account is enabled in
msdb so it depends on whether you have changed this or not.
Other than that, the account would just need the appropriate
permissions for the objects they are accessing or actions
they are performing. There are also the issues mentioned in
the articles above that need to be considered.
You may want to consider the approach mentioned in the
articles with using jobs and executing sp_start_job but some
of that will depend on security issues, what you are
executing, etc.

-Sue

On Fri, 30 Jul 2004 09:11:46 -0700, "kevin"
[quoted text, click to view]