468,505 Members | 1,768 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

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.SqlServer.Dts.Tasks.WebServiceTask.Webs erviceTaskException: The
Web Service threw an error during method execution. The error is: The
operation has timed out. at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMe thodInvokerProxy.InvokeMethod(DTSWebMethodInfo
methodInfo, String serviceName, Object connection) at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebSe rviceTaskUtil.Invoke(DTSWebMethodInfo
methodInfo, String serviceName, Object connection, VariableDispenser
taskVariableDispenser) at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebSe rviceTask.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
Feb 22 '08 #1
0 3474

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Rodrigo Bellusci | last post: by
3 posts views Thread by =?Utf-8?B?TWljaGFlbA==?= | last post: by
2 posts views Thread by pvong | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
reply views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.