Home Forums Programming Service Broker Sequentially processing messages in Service Broker Queue RE: Sequentially processing messages in Service Broker Queue

  • How does usp_ExecutePackage_TestPackage and usp_ExecutePackage_TestPackage1 execute the SSIS package? Is control returned to the procedure before the SSIS package has completed? If so, then setting max queue readers to 1 won't help. If the SSIS package has to complete before control is returned to the procedure, then setting max queue readers to 1 will help.