Error Message in DTS

Not sure if this is DTS related or ASP related ... so thought I would try here first.

I have several DTS Packages that I have set up for a client. I then created an ASP Page to list/run these packages so that the client doesn't have to open Enterprise Manager (training issue involved ... big one). Some of these packages require that a certain file be located in a certain directory to work. To avoid any nasty error messages I included an ActiveX script in the DTS to check to make sure the files exists ... if not display a message box to that effect, otherwise ... run the rest of the package. If running the package from Enterprise Manager ... the popup issue works great.

My problem ... If I run this from the ASP Page, the page just hangs. Is there anyway to have an error message popup within ASP from the DTS Package ... or do I have to create ASP related code in the page to check for this?

Thanks for any info you could provide.

I am sure you may have already thought of this, but I ran into it once before.

Be sure the login connection you use on the ASP page has sufficient rights on the SQL Server, and all corresponding pieces.

In the past, I have had to call a SP from the page which then launched the DTS package in order for it to work. It could have been my learning curve, however.

Good Luck!