November 9, 2009 at 3:04 pm
I was wondering if there was a way in SSIS to open a web page. I tried using an ActiveX Task using VB Script, but apparently I cannot get it to work. I am getting an error saying that the function cannot be found. When I put the same code in as a Scheduled Job, it runs with no end.
November 9, 2009 at 3:20 pm
You might try a script task NOT the ActiveX script. You would be running .NET instead of ActiveX script.
CEWII
November 9, 2009 at 3:46 pm
I think a script component task would be your best bet. We use the scripts for similar functionality.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 9, 2009 at 7:26 pm
I must be missing something simple. I have the following Script that I am using, but it is not working:
Dim objRequest
Dim URL
objRequest = CreateObject("Microsoft.XMLHTTP")
URL = "http://demantra/portal/loginpage.jsp"
objRequest.open("POST", URL, False)
objRequest.Send()
objRequest = Nothing
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply