Lock an SSIS package from multiple simultaneous executions

Question

I have an SSIS package(Package1.dtsx) that been deployed to SSISDB. currently I scheduled the package with some parameters in sql server agent.

how do I lock the package(Package1.dtsx) if someone try to attempt running it in another sql server agent job with different parameters.

Answer 1

You can do this yourself by adding a flag and having your package check this flag before processing. Either quit out, loop until flag is clear or some other logic.

I personally have only ever had one agent per package and the agent handles the multiple execution scenarios.