WebBrowser control for SSIS script

• Gabe Weiny

  SSC Enthusiast

  Points: 193

  More actions

  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.

• Harry Lord

  Grasshopper

  Points: 15

  More actions

  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.

   

• Gabe Weiny

  SSC Enthusiast

  Points: 193

  More actions

  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.