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 -
<allow user = "?">
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.