开发者

Consume a WCF service from within a Transformation in SSIS

I have a WCF serv开发者_开发知识库ice that I need to consume from within an SSIS Data Flow Transformation, and I'm trying to figure out how to go about that.

I'm aware of the Web Service Task, but that is for Control Flow tasks, and this needs to happen within the Data Flow Transformation.

Note that this service is COM visible, so that's an option if that will be the easiest way to do it.

What are my options?

Thanks in advance.


I have never tryed it but perhaps you can call the service from data flow's script component. You can also develop whole new component for SSIS.

I doubt that calling service for each processing record will make your data flow terribly slow and for large datasets probably useless.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜