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 Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 5:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:02 AM
Points: 6, Visits: 62
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 #1384930
Posted Monday, November 19, 2012 9:39 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 10:07 AM
Points: 828, Visits: 1,702
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.
Post #1386465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse