Irena Kennedy posted a lengthy entry on choosing the right integration technology from the growing stack of frameworks and servers Microsoft Offers. Included in the entry as candidates are: SQL Server Integration Services (SSIS), SQL Server Service Broker (SSBS), SQL Server Replication, MSMQ, BizTalk and WCF.
Plenty of good stuff to consider. Highly Recommended! (Found via Richard Seroter).