I create the wcf service hosted in IIS.
I tried to use "Web Service Task" to call this wcf service in SSIS package.
in the Http Connection manager,
server url : http://localhost/WCFService/Service.svc
time out : 300
and then test connection successed.
in the input of web service task editor,
I can select the input service, and method -that means I can use the wcf
service, right?
But it returns error msg,
[Web Service Task] Error: An error occurred with the following error
message:
"Microsoft.SqlS erver.Dts.Tasks .WebServiceTask .WebserviceTask Exception: The
Web Service threw an error during method execution. The error is: The
operation has timed out. at
Microsoft.SqlSe rver.Dts.Tasks. WebServiceTask. WebMethodInvoke rProxy.InvokeMe thod(DTSWebMeth odInfo
methodInfo, String serviceName, Object connection) at
Microsoft.SqlSe rver.Dts.Tasks. WebServiceTask. WebServiceTaskU til.Invoke(DTSW ebMethodInfo
methodInfo, String serviceName, Object connection, VariableDispens er
taskVariableDis penser) at
Microsoft.SqlSe rver.Dts.Tasks. WebServiceTask. WebServiceTask. executeThread() ".
it looks like timeout issue, but I tried to use web service(asmx) with same
code, and it works fine in SSIS package.
So, I wonder whether I can call wcf service hosted in IIS from SSIS package.
please, advice me.
soworl