Keep getting an Error on SSIS

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: OSB-386200: General web service security error.
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()".
Task failed: Web Service Task
. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jayraj Chhaya2y ago
The error 0xC002F304 in SSIS indicates a problem with the Web Service Task, specifically a web service security error. To address this, you can try the following steps:
1. Check the web service security settings and ensure they are correctly configured.
2. Verify the method execution in the web service.
3. Adjust the MaximumErrorCount property in SSIS to allow for more errors before failing.
4. Review the error message details for more specific information on the issue. By following these steps, you can troubleshoot and resolve the SSIS error 0xC002F304 related to the Web Service Task.