Post reply

Errors with SSIS web service task

  • December 1, 2017 at 9:38 pm

    #324878

    I create a SSIS web service to retrieve data from remote server, Server connection is good, but get the following error:

    [Web Service Task] Error: 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: Could not send Message..
     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()".

    Can somebody point out to me how to fix the error?

    Also, I would like to get learn more about web service with visual studio, can somebody suggest some reading?

    Thanks,

  • December 3, 2017 at 4:21 am

    #1970423

    Have you checked permissions and firewall settings?
    😎

  • December 5, 2017 at 9:05 pm

    #1970836

    Wrox the publisher has a good book on SSIS that I read some time back. I'm sure they have updated versions on the subject and that would make good reading. 

    As far as your error , if you type the service URL into your browser, does it land you somewhere?

    ----------------------------------------------------

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply