SSIS Script Task

  • 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.

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

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