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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top