Run SQL DTS package from ASP?

[geekchik]

SQL Server 7.0, Win 2k Pro

I've set up a DTS package to retrieve 2 files from our mainframe, execute a script that pulls certain info from both files and puts it in delimited format, and update a table in an SQL db with the new info.

I want to have a button on a page which, when clicked, will execute the DTS package to bring the data up to date, and then refresh the page so the new data's incorporated into the page's dynamically generated menu. So far, I haven't been able to find much on DTS and ASP.

Any suggestions, links, etc.?

Thanks,

geekchik

 

[alistairpaul]

create a stored procedure to fire off the execution of the dts package..

example:

http://www.aspalliance.com/chrisg/default.asp?article=61

hope this helps.