Asked By NMahmoud
22-Jan-10 11:55 AM

Hi everyone,
I am trying to use SSIS to post SOAP messages to Ektron services.
I created a HTTP connection, with "use credentials", Nothing set in the
Proxy tab.
I used that connection in a web service task, when I run it, the task it
gives me the following error
Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred
with the following error message:
Web Service threw an error during method execution. The error is:
System.Web.Services.Protocols.SoapException: Credentials must be specified
at Ektron.Services.User.IsARoleMember(CmsRoleIds RoleId).
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
Warning: 0x80019002 at Package: SSIS Warning Code
DTS_W_MAXIMUMERRORCOUNTREACHED. 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.
SSIS package "Package.dtsx" finished: Failure.
the folloing is a sample of the xml messages I am trying to post.
xmlns:tem="http://tempuri.org/">
in the web server we have "anonymous Authentication" and "Forms
Authentication" Enabled
would anyone have an idea what the problem is, I am new to SSIS and