I am trying to use the Web Service Task in SSIS to access the TopFilesByIP method. I am unable to do so. Look at the SSIS error below. According to the error it seems like AuthorizationCode is not set but that is not the case. I added that in the "Input" field on WebServiceTask. 

 

Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: SSWeb.AuthorizationCode in config\AppConfig.xml file must be set and must be >= 10 characters long in order to use this web service.
   at SSWeb.Services.Query.ExecuteQuery(String authUserName, String authPassword, String authorizationCode, String queryName, String[] keyValuePairs)
   --- End of inner exception stack trace ---.
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

 

Additional Questions:

Can I make an http request like

http://stats1.XXXXX.com/Services/query.asmx/ExecuteQuery?authUserName=XXXX&authPassword=XXXXX&authorizationCode=XXXXXX&queryName=/DataMining/TopFilesByIP