If you are using Azure SQL VM than just it is just like have a VM in which you can install drivers and migrate SSIS packages to. For Azure SQL DB, it is bit tricky, the Azure SQL DB, there is no SQL agent nor SSIS. Don't know if it is the best way but the way I am doing it is to have the DB in Azure SQL Database. Have a VM SQL server with the standard edition and place the SSIS packages and job in there. Inside the SSIS packages, the destination connection is Azure SQL DB so when the jobs complete the data is in Azure SQL Database. This way I don't have to use automation in Azure SQL database and use the jobs to schedule whichever way I want.