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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply