ssis script task to connect to website

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » ssis script task to connect to website

ssis script task to connect to website

Rate Topic

Display Mode

Topic Options

Author

Message

kwyman

Posted Thursday, November 15, 2012 7:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:47 AM
Points: 3, Visits: 19

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 »

Permissions