在Azure中运行SSIS包 [英] Running SSIS packages in Azure

问题描述

我期待我的web应用程序迁移到云中。 Web应用程序使用SQL来存储数据来自约10 SSIS packages.The数据包本身需要不到5个小时运行在一天组合和数据，他们发送量是非常小的小于5MB一天

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.

因此​​，免费的网络解决方案的Azure似乎适合用于数据存储和运行​​网站的需要，但它允许一个调度SQL Agent作业和执行SSIS包
我看着VM AZURE解决方案，但它是挺高的我此刻的口袋。
或者有人可以告诉我到一个托管服务，能满足我的要求，仍然是便宜？

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?

推荐答案

通过免费网页Azure的，如果你的意思是Azure的网站，那么它是不可能的。

By Free Web Azure, if you mean Azure Websites, then it is not possible.

即使SQL Azure的数据库不支持SQL代理以及SSIS。

Even Azure SQL database doesn't support SQL Agent as well as SSIS.

您最好的选择就是使用Azure的IaaS的虚拟机，你已经提到（的 http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-sql-server/ ）

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

这篇关于在Azure中运行SSIS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！