Click here to Skip to main content
12,817,428 members (33,333 online)
Rate this:
Please Sign up or sign in to vote.
See more: SSIS web.Config

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">
        <allow user = "?">
        <allow roles="DOMAIN\ROLENAME"/>
        <allow users="DOMAIN\USERNAME"/>

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
Updated 13-Feb-13 7:21am

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 13 Feb 2013
Copyright © CodeProject, 1999-2017
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