Helpful information and examples on how to use SQL Server Integration Services.
What’s new in SSIS? In a word: Lots.
It’s been a lot of fun showing off the new SSIS features and functionality – the hardest part has been fitting it all into a 60 minute timeslot. This CTP is close to feature complete – the rest of the time we have for the Denali release will (mostly) be spent improving and polishing what’s there. However, you can expect a couple of new features to slip in for the final release - we have to leave some surprises for RTM, right?
There have been two major themes for SSIS in the Denali release – improving the Developer Experience, and making SSIS solutions easier to Deploy, Configure, and Manage.
We wanted to make the designer easier to use, as well as deliver productivity enhancements to delight our existing users. Some of the major features here include:
The deployment and configuration improvements revolve around the new SSIS Catalog (or SSIS Server). This catalog is essentially a SQL application - a user database on a SQL instance (SSISDB) with a set of stored procedures and a T-SQL API. In addition to the server, we’ve introduced a new Project model for bundling your packages together to simplify deployment, and a new Parameter model to make configuration and management a little more straight forward. This CTP contains a number of enhancements to what was delivered in the previous CTP, as well as a bunch of new features, including:
We have made further improvements to the new functionality that appeared in the previous Denali CTP – thank you all for your feedback!
In addition to the major themes, we’ve made many small enhancements and quality improvements through out the product. Some of the more noticeable ones include:
Here are some additional links if you’re looking for more information.
I was hoping for parallel FOREACH evaluation, which was briefly introduced in SSIS 2005 beta but droppped and never added again.
I've been expecting it since .NET 4 (PLINQ), but it hasn't turned up yet...
I have installed SQL Server Denali CTP [ 3]. It looks great. .............We might have heard about lot of new things in SSIS Denali before the release of CTP 3.