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

问题描述

我希望将我的网络应用程序移至云端.Web 应用程序使用 SQL 来存储数据，其中数据来自大约 10 个 SSIS 包.这些包本身需要不到 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.

因此，免费的 Web Azure 解决方案似乎适合数据存储和运行站点的需要，但它是否允许安排 SQL 代理作业和执行 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?

推荐答案

Free Web Azure，如果您指的是 Azure 网站，那么它是不可能的.

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

即使是 Azure SQL 数据库也不支持 SQL 代理和 SSIS.

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

您最好的选择是使用您已经提到的 Azure IaaS VM ( 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屋！