November 14, 2012 at 5:03 pm
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.
November 19, 2012 at 9:39 am
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 2 (of 2 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