THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Jorg Klein, Microsoft Business Intelligence consultant/architect from the Netherlands

The next version of SSIS is coming!

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!

Published Monday, October 25, 2010 5:04 PM by jorg
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Seth Lynch said:

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.

Seth

October 25, 2010 10:42 AM
 

Gene said:

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!

October 25, 2010 1:13 PM
 

Abhishek said:

In both the 2008 and R2 releases, SSIS had nothing much. I I don't see anything of significance here as well

All the 4 points you mention look like cosmetic changes to me

- 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!

- New icons and rounded corners for tasks and transformations

- Data flow sequence container

If you compare SSIS to any other ETL tool starting from Informatica to Pentaho Kettle you will find that it lacks so many features.

October 26, 2010 2:28 AM
 

jorg said:

Abhishek,

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!

October 26, 2010 4:08 AM
 

Peter said:

November 9, 2010 9:42 AM
 

Jorg Klein said:

SQL Server Denali (SQL Server 2011) CTP1 has been released! Download it here SQL 2011 is expected to

November 9, 2010 10:12 AM

Leave a Comment

(required) 
(required) 
Submit

About jorg

Jorg Klein, Microsoft Business Intelligence consultant/architect from the Netherlands.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement