Calling a WCF Service directly or via an Event from an SSIS Package?

• I.W Coetzer

  Ten Centuries

  Points: 1060

  More actions

  June 12, 2009 at 1:58 am

  #135099

  Hi,

  How would one setup an SSIS Package to call a WCF service that is hosted on another server by raising an event to it?

  Or can one only call it asynchrounsly and somehow not have the ssis package wait for a response.

  I need to call a service and leave it be, in other words I will not want to wait for a return, I will want to call it and pass it a parameter that will be a primitive data type.

  Thanks

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  June 12, 2009 at 8:54 pm

  #1008980

  This is more of an implementation details on the wcf service side. The wcf service will need to ensure the method returns immediately. Look into the WCF IsOneWay attribute, the possibility of using the net msmq binding, and also the threadpool. You may want to simply chuck the request onto the threadpool so the actual work gets done later and the method returns immediately to the caller (ssis package).