Click here to Skip to main content
11,492,639 members (62,171 online)
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 7:09am
Edited 13-Feb-13 7:21am
(no name)34.1K
v2

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 379
1 Maciej Los 266
2 KarstenK 210
3 CPallini 208
4 Sascha Lefèvre 195
0 Sergey Alexandrovich Kryukov 9,943
1 OriginalGriff 8,610
2 Sascha Lefèvre 3,609
3 Maciej Los 3,372
4 Richard Deeming 2,440


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 13 Feb 2013
Copyright © CodeProject, 1999-2015
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