can I call the wcf web service hosted in IIS from SSIS package?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • =?Utf-8?B?c293b3Js?=

    can I call the wcf web service hosted in IIS from SSIS package?

    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
Working...