SQL Server Integration Services (SSIS) 2008/2008 R2 includes a number of component, data management and performance enhancements. This topic
briefly outlines these enhancements. For more information in Books Online, see
What's New (Integration Services). For an audio podcast, see
What's New in SQL Server Integration Services 2008.
I think it's correct to say that the only new feature BETWEEN SSIS 2008 and 2008 R2 is the new setting Use bulk insert when available, in the ADO NET Destination Editor.
Otherwise, I think SSIS 2008 is identical in functionality to SSIS 2008 R2.
Can't wait for the next release...
What’s New in Microsoft SQL Server Code-Named “Denali” for SQL Server Integration Services - channel9.msdn.com/.../DBI317
For more information about the new SSIS Denali features, see the "30 Days of SSIS" series on the SSIS Team Blog, at blogs.msdn.com/.../30daysofssis .
Very useful. Hope in SQL Server 2012 it got even better!!
For more information about What's new in SSIS 2012, check out this BOL topic. -- msdn.microsoft.com/.../bb522534.aspx