All geek questions in one place

Call SSIS from BizTalk Orchestration

I have a scenario: I need to move a huge 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 process the amount of data that needs to be transferred.

We decided to organize BizTalk Orchestration to launch the SSIS package, which does the actual heavy lift. However, there is a caution that we should be able to transfer information to SSIS, such as the location of the file and information on how to break certain data.

My question is: what is the best way to call SSIS from Orchestration with these parameters in mind? Should I create a web service around it? Is there an adapter or stored procedure that I can call? Or is there a way to call him directly from the Orchestra?

+3
source share
2 answers

In the end, we had to pass the variables to the SSIS package in order to associate it with the orchestration that launched it. We also needed to use the same orchestration, but at the same time run different SSIS packages based on the receiving location.

We ended up with this solution:

  • Orchestration calls a stored procedure with two parameters: correlation GUID and place of receipt.
  • The stored procedure stores the required values ​​in the SSIS configuration table.
  • SQL-
  • SSIS.
  • SSIS XML .
  • BizTalk XML GUID.
  • BizTalk .

, , .

0

Source: https://habr.com/ru/post/1737422/

More articles:


All Articles