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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call C# dll from sql server 2000 dts? 5
call, run or execute a DTS package from an APS (aspx) page? 5
Call DTS Package from ASP.NET, asynchronously 3
Execute SSIS package from aspx page 2
Permission required to execute a DTS package from ASP.NET app 2
Can you call a DTS in MSSQL programitcally? 1
SQL DTS from webserver .dll? 2
Problem with running a DTS Package from an ASP.NET page 1

Back
Top