Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SSIS web.Config
Hi,
 
I have created one SSIS Package which contains the Web Service Task. The Web Service Task is using the HTTP Connection Manager which is pointing to the address where the Web Service is hosted. When we execute the Task without any credentials, it throws the error -
 
Error 401 - Unauthorized : The Remote Server returned an Error.
 
When we give the credentials, then the Test Connection results in success.
 
The Asp.Net Web.Config contains the code like below -
<location path="SERVICE">
    <system.web>
      <authorization>
        <allow user = "?">
        <allow roles="DOMAIN\ROLENAME"/>
        <allow users="DOMAIN\USERNAME"/>
   </authorization>
  </system.web>
</location>
 
However, we don't have to give the username & password in HTTP Connection Manager but on the other hand the webservice must be executed by the roles and users mentioned in Web.Config file.
 
Please suggest how can we achieve this?
 
Thanks in advance.
Posted 13-Feb-13 6:09am
Edited 13-Feb-13 6:21am
33.9K
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 435
1 Sergey Alexandrovich Kryukov 200
2 Yogesh Kumar Tyagi 180
3 Richard Deeming 180
4 RyanDev 115
0 Sergey Alexandrovich Kryukov 6,405
1 OriginalGriff 5,798
2 CPallini 2,473
3 Richard MacCutchan 1,647
4 Abhinav S 1,530


Advertise | Privacy | Mobile
Web04 | 2.8.140821.2 | Last Updated 13 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100