Post reply

WebBrowser control for SSIS script

  • August 16, 2006 at 12:13 pm

    #114202

    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

    #655619

    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

    #655740

    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 2 (of 2 total)

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