Adapters in SSIS?

Are there adapters available to connect to SSIS for

1. Siebel

2. IBM MQ

Please let me know what are the alternatives if they don't exist.

I am still struggling to understand the core functionality difference between BizTalk and SSIS?

Thank you.

Not out of the box but I believe a company called Attunity build adapters for other systems so you might find them useful.

Core difference between SSIS and BizTalk? That's an incredibly open question. At a very very high level BizTalk is for interactive real-time integration typically on small data packets whereas SSIS is batch and works on much larger volumes of data.

You wouldn't want to move 1m rows about with BizTalk and similarly you wouldn't want to integrate your eCommerce app with your supply-chain app using SSIS.

Hope that helps.

-Jamie

|||Hi Jamie, thank you for your response. So does that mean, integrating applications goes with BizTalk and moving bulk data goes with SSIS? Please explain a little bit further if you can. I am trying to really understand how and why SSIS is different from BizTalk
|||

Yeah, that is another way of stating what I said.

By sheer coincidence I've just come across this useful post explaining the difference between SSIS and BizTalk http://blogs.msdn.com/william_zentmayer/archive/2005/10/17/481992.aspx

Perhaps googling would help: http://www.google.co.uk/search?hl=en&q=biztalk+ssis&meta=

-Jamie