March 14, 2013 at 11:23 pm
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
March 15, 2013 at 3:32 am
Hello Tava,
From where the username and password will be taken?
March 15, 2013 at 7:29 am
What is your exact scenario?
Normally you would use a webservice to exchange data with a website.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 18, 2013 at 10:57 pm
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.
March 19, 2013 at 1:33 am
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 20, 2013 at 3:42 pm
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?
March 20, 2013 at 3:50 pm
No idea, haven't tried this myself before.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply