I'm working in an environment where there's a need for certain users to be
allowed to execute a pre-made DTS package to update a database. Running a
schedule for the update isn't sufficient because at times it may need to be
done immediately. What is the best way to allow a user without Enterprise
Manager to be allowed to execute a DTS package? Is there a way I can do it
via an ASP page?

Thanks

1. Yes, it is possible to run a DTS Package from an ASP page, please see
the references below for more information:

HOW TO: Use DTS Package Events in Visual Basic .NET - ID: 321525
http://support.microsoft.com/?id=321525

INF: Execute a SQL Server DTS Package from Active Server Pages - ID: 252987.
http://support.microsoft.com/?id=252987


2. some alternate solutions are
-Use DTSRUN.exe command prompt utility (you can run this via the SHELL
command in VB)
-Create a sqlagent job which executes the DTS package and manually run the
job using sp_start_job

References:
SQL Books online topics:
DTS Programming Samples
DTS Tools
Creating DTS Packages with the DTS Object Model
Programming DTS Applications

Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx