Can I call a SQL Server 2000 DTS package from an aspx?

[Guest]

How can I do this?

 

[Jeff Sheldon]

Lanem,

I would suggest taking a look at xp_cmdshell and using it to run dtsrun
from within a stored procedure. Take a look in BOL for information about
dtsrun.

-Jeff

 

[GD]

xp_cmdshell requires administrator right to run.

GD

 

[Scott Allen]

There are many articles out there on using DTS from .NET languages:
http://www.google.com/search?hl=en&q=dts+c#

The two biggest hurdles in an ASP.NET environment are keeping the call
authenticated and authorized. You'll want to look at running the
ASP.NET process under a well known account, or using impersonation.