I need to get data from web services with credentials using SSIS. I used the web service task to connect to the web service using the credential but I got No authorization 401 message. I tried to use script task to connect to the web services but i am having issues references the proxy class given to me. Does anyone have idea of how to go about this?BI Developer

what is the webservice which you want to connect? is it WCF or WebService?http://www.rad.pasfu.com

WebServiceBI Developer

WebServiceBI Developer

You should be able to accomplish the goal by using the WebService Task. To do this using the script - http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/28/consuming-web-services-in-ssis-script-task.aspx Most importantly, you need to troubleshoot the connectivity issue 401 FIRST, before you try to build your package. Did you try accessing the webservice using IE?Arthur My Blog

Thanks I am now able to access the web services and use the proxy class to accessing the credential and assign values to them. The issue is that the web method I needed is returning three string as a parameter list. I am having problem retrieving the data from the web method. How can I debug within script component? I am getting error you cannot bebug or run this project, becuase the required version of Microsoft application is not installed?BI Developer

What are your steps to debug?Arthur My Blog