I am creating a SSIS package that needs to call a webservice but I am receiving an error message containing "401 Unauthorized" when the package runs.
I opened the HTTP Connection Manager Editor and checled the credentials and then pressed the "Test Connection" button. When I press this button I get "The remote server returned an error: (401) Unauthorized." If I navigate to the web service URI using IE and the same credentials I am able to see the service description. Any idea what else I should check to resolve this problem?
Joel Ivory Johnson