Difference between SSIS and Biztalk server

Posted by Ghousal under BizTalk Server on 3/12/2010 | Views : 7189 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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

0	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

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

Latest Posts