My company is building an ETL engine using SQL Server Integration Services. I need to build an application to orchestrate various processes in the engine. The application would have use a schedule to determine the appropriate time to run each process, and the processes can run asynchronously.
I believe I could use BizTalk for this application but I’m not sure how to structure the application. For example, how could I program BizTalk to run an SSIS package upon receipt of a message? Would I use the Scripting Functoid?