Calling SSIS from BizTalk Orchestration

Posted by aceinthehole on Stack Overflow See other posts from Stack Overflow or by aceinthehole
Published on 2010-03-17T20:50:27Z Indexed on 2010/03/17 21:11 UTC
Read the original article Hit count: 452

Filed under:
|

I have a scenario were I need to move a vast amount of data, and I need to use BizTalk to control the flow and contain the business logic. The problem is that BizTalk will not be able to handle the amount of data that needs to be moved.

We have decided to a BizTalk Orchestration to kick off an SSIS package that does the actual heavy lifting. However, there is a caveat in that we have to be able to pass information into SSIS such as file location and info about how to split certain data up.

My question is, what is the best way to call into SSIS from an Orchestration given those parameters? Should I build a webservice around it? Is there an adapter or stored procedure that I can call? Or is there a way to call it directly from the Orchestration?

© Stack Overflow or respective owner

Related posts about BizTalk

Related posts about biztalk-2009