I am looking to move my web app to the cloud. The web app uses SQL to store data which the data comes from about 10 SSIS packages.The packages themselves require less than a 5 hours to run all combined in a day and the amount of data they send is very small less then 5MB in a day.
So the Free Web Azure solution seems to fit the need for data storage and running the site but does it allow one to schedule SQL Agent jobs and execute SSIS packages I looked at the VM AZURE solution but it is pricey for my pockets at the moment. Alternatively can someone direct me to a hosting service that can meet my requirements and still be cheap?
You can now move your SQL Server Integration Services (SSIS) projects, packages, and workloads to the Azure cloud. Deploy, run, and manage SSIS projects and packages in the SSIS Catalog (SSISDB) on Azure SQL Database or SQL Managed Instance with familiar tools such as SQL Server Management Studio (SSMS).
You add an Execute SSIS Package activity to the pipeline and configure it to run your SSIS package. On your Data Factory overview or home page in the Azure portal, select the Open Azure Data Factory Studio tile to start the Data Factory UI or app in a separate tab. On the home page, select Orchestrate.
On the Deployment settings page of Integration runtime setup pane, if you want to deploy your packages into SSISDB (Project Deployment Model), select the Create SSIS catalog (SSISDB) hosted by Azure SQL Database server/Managed Instance to store your projects/packages/environments/execution logs check box.
By Free Web Azure, if you mean Azure Websites, then it is not possible.
Even Azure SQL database doesn't support SQL Agent as well as SSIS.
Your best bet is to use Azure IaaS VM as you already mentioned ( http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-sql-server/ )
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With