I wanted to get SSIS to call a service in my application if it has successfully completed an operation. I quickly built the following service using WCF:
public interface ISsisNotifications
public class SsisNotifications : ISsisNotifications
public void UpdatedDatabase()
I didn't ask for something complex like (gasp!) passing parameters, or doing something with the result. All I wanted was the simplest possible scenario. It refused to do that. I found this post about similar problems, but even after hand editing the dtsx file (a daunting task), it still failed to work.
An ASMX service works just fine, but of course that this means that I have to separate technologies just for something as simple as that. Yuck!