August 16, 2006 at 12:13 pm
I need to retrieve a text file that can only be accessed by navigating through an asp driven website (filling out login forms, etc..). In other words, there is no direct URL to specify to a WebClient to download from.
I know you can navigate programatically using a WebBrowser control in a Windows Forms application.
But I can't figure out if it is possible to do all that in a vb.net script run directly as part of an SSIS package.
Any help is greatly appreciated.
August 18, 2006 at 6:59 am
This is not a solution but you can do HTML posts from ActiveX or .NET code.
There are some examples you can find on the internet. Using a post allows code to "fill" forms and submit them. The code for this is not simple but it can be done.
Here are some examples:
http://renegademinds.com/Default.aspx?tabid=47
http://www.seattleu.edu/it/findit/articles/8235288321.html
Hope this helps.
August 18, 2006 at 1:43 pm
Thank you for your response.
The vb.net code at http://renegademinds.com/Default.aspx?tabid=47 shows how to use the WebBrowser control in a Windows Forms application. I am trying to do this in a Script Task in SSIS. It is not possible to use a WebBrowser control in this case.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy