The latest releases of SQL Server contained (almost) no new SSIS features. With the release of SSIS 2008 the ability to use C# scripts, the improved data flow and the cached lookup were most thrilling new features. The release of SQL 2008 R2 only gave us the ability to use a bulk insert mode for the ADO.NET destination, which was a bit disappointing.
Fortunately Matt Mason from the SSIS team announced that the next version of SQL Server (SQL 11) contain quite some exiting new functionality for SSIS!
– Undo/Redo support. Finally, this should have been added a long time ago 😉
– Improved copy/paste mechanism. Let’s hope we keep the formatting of components after copy/pasting them!
– Data flow sequence container
– New icons and rounded corners for tasks and transformations
– Improved backpressure for data flow transformations with multiple inputs (for example a Merge Join). When one of the inputs get to much data compared to the other, the component that receives the data can tell the data flow that it needs more data on the other input
– The Toolbox window will automatically locate and show newly installed custom tasks
I’m Curious about the first CTP!
I would have liked to have seen some non-ado.net drivers for ODBC.
Cut and Paste not messing up the package layout – that would be nice.
I *HOPE* the SSIS Team will look into utilizing the version of Visual Studio you may already have installed. I hate having multiple copies of Visual Studio installed, it is also a waste of my computers resouces.
One finial rant SQL Server 2008 R2 SSIS **SHOULD** have utilized Visual Studio 2010 not 2008!
You are right, the changes mentioned here are not really significant. But the fact MS is working on SSIS gives me the hope that exiting additions will be included in the next version!
CTP 1 – http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9