Run a DTS package from a web page

[cricketer1]

Is it possible to run a DTS package from a webpage (.HTML) and how?

thanx
cricketer1

 

[JamesLean]

Not from a static HTML page, no. You would need to use some kind of server-side script, eg ASP. You could then execute the dtsrun program to start the DTS package.

Look up dtsrun in BOL. The ASP forum is here: forum333 --James

 

[tlbroadbent]

Check the following link for info on executing a DTS package from an ASP page.

http://www.sqldts.com/default.aspx?6,104,207,7,1

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[cricketer1]

thanks for pointing me in the right direction
cricketer1

 

[tlbroadbent]

In the future, please post DTS questions in forum961. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm