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 - Automatic Login to a website Expand / Collapse
Author
Message
Posted Thursday, March 14, 2013 11:23 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 27, 2014 8:38 PM
Points: 90, Visits: 420
Hi All,

I havent been able to find a starting point or solution when searching the internet for my scenario which makes me think it might not be possible.

I'm trying to build a SSIS package that will open a website and then automatically enter the UserName & Password for me? Is this possible, because manually the user will need to click on the username/password text box to enter details.

Can the above be automated? any help would great.

Thanks
Tava
Post #1431358
Posted Friday, March 15, 2013 3:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
Hello Tava,

From where the username and password will be taken?
Post #1431425
Posted Friday, March 15, 2013 7:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
What is your exact scenario?
Normally you would use a webservice to exchange data with a website.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1431527
Posted Monday, March 18, 2013 10:57 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 27, 2014 8:38 PM
Points: 90, Visits: 420
Koen Verbeeck (3/15/2013)
What is your exact scenario?
Normally you would use a webservice to exchange data with a website.


Hey, the exact scenario to do this manually is like this

1. Go to a secure HTTPS site
2. Click on the username section and enter a username
3. Click on password and enter password
4. click on a link to open a folder
5. click on the file to download.

Obviously i would like that all automated behind the scenes, with the file being controlled by a variable to get latest file.

think of login into say G-Mail, that logic go to the site, enter details and login,

hope that makes sense.

Post #1432469
Posted Tuesday, March 19, 2013 1:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
Normally this would be done through FTP or a web service, but I assume you don't have control over this.
You can try with a HTTP connection manager:

Downloading a file over HTTP the SSIS way




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1432508
Posted Wednesday, March 20, 2013 3:42 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 27, 2014 8:38 PM
Points: 90, Visits: 420
I'll give that a go but what is confusing is in Connection manager I can enter in a Username/Password which is what i want, but the site doesnt prompt me i need to click on the box. Would i need to enter the connection string as a pre-set login with details already captured?
Post #1433514
Posted Wednesday, March 20, 2013 3:50 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:00 AM
Points: 13,520, Visits: 11,313
No idea, haven't tried this myself before.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1433518
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse