Search code examples
sqlsql-server-2008ssisbiztalkbiztalk-2010

Biztalk vs SQL Server Integration Services

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;

  1. Where to use BizTalk vs SSIS?

  2. Does SSIS have VS 2010 project template like we have for BizTalk Server?

  3. For SSIS development which IDE should be used, can we use VS 2010 or need to work in SQL Server Management Studio?

  4. What are the shortcomings of SSIS that BizTalk overcomes?

Solution

  • 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.