Click here to Skip to main content
11,411,494 members (65,969 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 OriginalGriff 213
1 Sergey Alexandrovich Kryukov 149
2 Sascha Lefévre 110
3 Dave Kreskowiak 90
4 RyanDev 75
0 Sergey Alexandrovich Kryukov 8,920
1 OriginalGriff 6,983
2 Maciej Los 3,430
3 Abhinav S 3,248
4 Peter Leow 3,059


Advertise | Privacy | Mobile
Web03 | 2.8.150414.5 | 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