As I like to say, don't fret! This is pretty easy to do using straightforward, tried & true on-premise SQL Server technologies:
- Linked Server - A Linked Server is used to execute Azure SQL Database queries using four-part names (server.database.schema.object).
- Stored Procedures - The SSISDB create_execution and start_execution stored procedures are used to initiate package execution.
- SQL Agent Job - A SQL Agent Job is used to schedule the execution of the SSISDB create_execution, start_execution, etc. stored procedures.
There you have it. A rather painless way to execute Azure-based SSIS packages from your traditional SQL Server instance. This can be useful when migrating from on-premise and/or IaaS to PaaS.