问题:

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?

回答1:

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/ )

回答2:

dualcorp has developed a dll to use ssis online. This name is essis a trial can be find on nuget and the llcence on https://www.dualcorp.fr/Product.aspx?id=jKIoPSeLL9plO8H1ZBAePg==

回答3:

If you use Amazon Web Services, even the free version of the service allows you to create Ms SQL Server databases in the cloud that have the SSIS catalog and the Server Agent available