SSIS Script Task

• kwyman

  SSC Veteran

  Points: 210

  More actions

  November 14, 2012 at 5:03 pm

  #284839

  Can anyone help me with adding log in information to a script task which goes to a webpage?

  The current code I have is :

  string website = "http://www.findafosters.com/formbuilder/export_entries.php?id=9&type=csv"; //or get it from a ssis variable

  System.Diagnostics.Process.Start("iexplore.exe",website);

  When I run the task it opens the web page but this page requires user and password.

  I am hoping I can add the user name and password to the above code. If logged in, this page triggers the csv export I need for a database I am building.

  Any help would be greatly appreciated.

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  November 19, 2012 at 9:39 am

  #1560425

  I'd strongly recommend against trying to use SSIS to do that directly. The .NET scripting environment within SSIS is pretty limited. You should instead write a .NET script separately, and then use the Execute Process task to execute that script. You can then pass any necessary information to it.