Biztalk 与 SQL Server 集成服务
我参加了 BizTalk 2010 培训，发现很有帮助，但当我开始阅读有关 SQL Server Integration Services 的内容时，我感到非常困惑，所以我有以下问题；
在哪里使用 BizTalk 与 SSIS？
SSIS 是否有像 BizTalk Server 那样的 VS 2010 项目模板？
SSIS开发应该使用哪个IDE，我们可以使用VS 2010还是需要在SQL Server Management Studio中工作？
对于BizTalk 克服了 SSIS 的哪些缺点？
I took a training on BizTalk 2010 and found very help but I got very confused when i started reading about SQL Server Integration Services, so I have following questions;
Where to use BizTalk vs SSIS?
Does SSIS have VS 2010 project template like we have for BizTalk Server?
For SSIS development which IDE should be used, can we use VS 2010 or need to work in SQL Server Management Studio?
What are the shortcomings of SSIS that BizTalk overcomes?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我认为根本的区别在于 SSIS 被设计为按计划的时间间隔或一次性批次运行。 Biztalk 更加实时集成。
I think the fundamental difference is that SSIS is designed to run at scheduled intervals or one-off batches. Biztalk is more real-time integration.
我对 Biztalk 一无所知，但我确实经常使用 SSIS。
是的。在 SQL Server 安装程序中，安装 Business Intelligence Development Studio 和 Integration Services。这会将 SSIS 模板添加到 Visual Studio。
Visual Studio 或 BIDS。 BIDS 实际上只是一个用于 SSIS、SSRS 和 SSAS 开发的 Visual Studio shell。您可以进行服务器配置并与从 SSMS 中构建的包进行交互，但您可以在 VS 或 BIDS 中进行开发。
I don't know anything about Biztalk, but I do work with SSIS somewhat regularly.
Yep. In the SQL Server installer, install Business Intelligence Development Studio and Integration Services. That will add SSIS templates to Visual Studio.
Visual Studio or BIDS. BIDS is actually just a Visual Studio shell for SSIS, SSRS, and SSAS development. You can do server configuration and interact with the packages you've built from within SSMS, but you do your development in VS or BIDS.