SSIS script task to connect to website

Question

SSIS script task to connect to website

kwyman

SSC Veteran

Points: 210
More actions
November 15, 2012 at 7:49 am

#265439

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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

kwyman (11/15/2012)
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.

One thing is for sure, you do not want to invoke Internet Explorer from within an SSIS Script Task.

If you want to programmatically interact with a website using .NET code in a Script Task then I would recommend you have a look at the WebClient class. SSIS 2005 uses .NET Framework 2.0.

WebClient Class (.NET Framework 2.0)

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

COZYROC One Orange Chip Points: 28499 More actions · Answer 2

Check here for sample code.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 3

CozyRoc (11/15/2012)
Check here for sample code.

The site says under Requirements:

Depends on CozyRoc Script Task Plus component for implementing parameters user interface.

Is CozyRoc Script Task Plus something that must be purchased?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

opc.three (11/15/2012)
CozyRoc (11/15/2012)
Check here for sample code.
The site says under Requirements:
Depends on CozyRoc Script Task Plus component for implementing parameters user interface.
Is CozyRoc Script Task Plus something that must be purchased?

It is needed for better UI. However the script is available for everyone to see and can be modified not to use COZYROC's script attributes.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/