Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matcoland
Starting Member
1 Post |
 Posted - 2001-01-22 : 15:38:47
|
| I have a DTS package setup on MS SQL7, and have it scheduled to run once a day where it copies data from a foxpro database to a database on the SQL server. Sometimes data changes more often than once a day, in which case I have to manually run the DTS package. What I would like to do is call the DTS package from an ASP page, where a user could log in to an admin-type web page and click a link that runs the package. Anyone know how to code that into ASP? I am very new at DTS, so the more detail you provide the better off I will be.The IIS server and SQL server on two different machines so calling a simple command line from the web server wouldn't work unless there is a way to call a command file from the web server that would run on the SQL server???Thanks in advance for ANY help! |
|
|
|
|
|
Calling a DTS from an ASP page???