I ran DTS package in asp page. All steps are failed. Web
server and database server are on different server. I
couldn't figure out the problem.
You may also want to check the following for some more
INF: Execute a SQL Server DTS Package from Active Server
On Tue, 14 May 2002 06:11:20 -0700, "hy"
>I ran DTS package in asp page. All steps are failed. Web
>server and database server are on different server. I
>couldn't figure out the problem.
Here are a couple of the sites I've looked at:
I've basically just copied the code (but edited it to
reflect my server name, login name, etc), but it keeps
I've created the DTS, and if I right-click on it in
Enterprise Manager and press "Execute," it runs just fine.
I don't know much about Stored Procedures, but if you
think it would be easier for me to use them, I'd
appreciate any help.
I was told that using "sp_help_job" would give the ID, and
then I could just reference the ID in my ASP. I saw
that "sp_help_job" (and sp_start_job, too) is a system
stored procedure, but everytime I try to run it in Query
Analyzer, it says "Stored Procedure not found."
Thank you in advance!