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
BizTalk
|biztalk-2009
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