Difference between SSIS and Biztalk server

Posted by Ghousal under BizTalk Server on 3/12/2010 | Views : 4681 | Status : [Member] | Replies : 3
HI Team,

Can any one explain me what is main difference between Sql Server integration service(SSIS) and Biztalk server?

Thanks in advance.


Thanks & Regards
Ghousal




Responses

Posted by: Raja on: 3/12/2010 [Member] Starter

Up
0
Down

Biztalk Server 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...

Above quote has been copied from http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/db697eeb-d29e-42a1-af8a-d1beb03901ed

Please mark this as answer if it helps

Regards,
Raja, USA

Ghousal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Oliviajones on: 7/20/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,
BizTalk typically requires the creation of schema for the type of data being passed between parts of the application. It ships with several adapters for enterprise applications like SAP, Siebel, JDR, Oracle.

In SSIS if the application is SQL based, typically simple data flow tasks to move data between tables / database. It can also leverage the scripting component in the data flow task to use the business objects of the application.

For more instances on BizTalk server visit: http://www.athenainfotech.co.uk/free-biztalk-health-check for free consultancy services.

Thanks



Ghousal, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Oliviajones on: 7/20/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,
BizTalk typically requires the creation of schema for the type of data being passed between parts of the application. It ships with several adapters for enterprise applications like SAP, Siebel, JDR, Oracle.

In SSIS if the application is SQL based, typically simple data flow tasks to move data between tables / database. It can also leverage the scripting component in the data flow task to use the business objects of the application.

For more instances on BizTalk server visit: http://www.athenainfotech.co.uk/free-biztalk-health-check for free consultancy services.

Thanks



Ghousal, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response