Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssis script task to connect to website Expand / Collapse
Author
Message
Posted Thursday, November 15, 2012 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 5:41 AM
Points: 6, Visits: 56
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.
Post #1385171
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse