Post reply

Open an ASP Page from a DTS

  • July 28, 2003 at 9:13 am

    #160532

    Is there a way to open an asp page from within a DTS?

    I thought there would be a way to do it in an Active-X Script Task but can't seem to find anything in BOL or MSDN.

    Any help would be apprecitated!

    Matt,

    Peace Out!

    Regards,
    Matt

  • July 28, 2003 at 10:32 am

    #467319

    Found the answer in the "Execute Process Task".

    Matt,

    Peace Out!

    Regards,
    Matt

  • July 29, 2003 at 5:40 pm

    #467632

    In case you ever do need to open a web page from DTS using ActiveX task:

    Set WshShell = CreateObject("WScript.Shell")

    strRunfile = "http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14639 &FORUM_ID=19&CAT_ID=3&Forum_Title=Data+Transformation+Services+%28DTS%29&Topic_Title=Open+an+ASP+Page+from+a+DTS"

    WshShell.Run strRunfile

    Set WshShell = nothing

    Of course, maybe if I had tried the "Execute Process Task" I wouldn't have had to figure out the above ActiveX way.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply