Difference between SSIS and Biztalk

Hi

Can anybody please tell me the basic differences between Biztalk and SSIS and when to choose which technology over other?

Regards,

Sandeep Saran

SSIS is just a small piece of BizTalk. BizTalk is more Business to Business (B2B). SSIS is more simply, data integration.

I suggest you read the documentation for each on Microsoft's site to make your own judgments:
BizTalk
SSIS|||

I asked this question from a Microsoft tech evangelist and I will try and paraphrase the reply:

Biztalk is a "messaging" application basically. It is designed and optomized to move single transactions (called "messages", and consisting of relatively tiny amounts of data in each discrete "message") between different systems or processes in real time. It wraps all user data in XML. As a result, it is extremely verbose during the data movement. It is not fast and would not be very satisfactory to manipulate large data sets using batch processing. Performance would be abysmal most likely.

Whereas SSIS _is_ designed specifically to move and manipulate large datasets using extremely high performance batch processing...

|||

kenambrose wrote:

I asked this question from a Microsoft tech evangelist and I will try and paraphrase the reply:

Biztalk is a "messaging" application basically. It is designed and optomized to move single transactions (called "messages", and consisting of relatively tiny amounts of data in each discrete "message") between different systems or processes in real time. It wraps all user data in XML. As a result, it is extremely verbose during the data movement. It is not fast and would not be very satisfactory to manipulate large data sets using batch processing. Performance would be abysmal most likely.

Whereas SSIS _is_ designed specifically to move and manipulate large datasets using extremely high performance batch processing...

Think EDI - Electronic Data Interchange|||

Sandeep Saran wrote:

Hi

Can anybody please tell me the basic differences between Biztalk and SSIS and when to choose which technology over other?

Start with this whitepaper describing possible approaches:

http://www.microsoft.com/technet/prodtechnol/biztalk/2004/whitepapers/integration.mspx