I found a presentation from TechEd with the title ”What´s New in Microsoft SQL Server Code-Named Denali for SQL Server Integration Services”. The presentation is about 1 hour long and if you are interested in ETL development and SSIS I really recommend watching it. The presentation can be found here: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI317
I have watched the presentation and going to share my thoughts here…
For ETL developers one interesting thing coming in the next version of SQL Server is something Microsoft calls Data Quality Services. It will be a separate function of SQL Server and is briefly mentioned but not covered by the presentation above. A short blog post about DQS can be found here: http://siddhumehta.blogspot.com/2011/01/data-quality-services-and-ssis-in-sql.html
During the next release of SSIS two areas is on priority, firstly improving the developer experience and secondly making deployment easier when it comes to handling configuration, logging and managing connections eg. In order to make deployment easier a new server model will be introduced.
While watching the demos in the presentation I feel that the interface feels fresh and I really like the new ”column mapper” functionality – it will save us developers a lot of time!
The XML that makes up the packages has been restructured in order to work better with source control. Hopefully it will be a lot easier to use branching and merging with TFS now!
In the current version of SSIS handling configurations, logging and moving between environments can be a bit painful. Because of this, Microsoft will introduce a new server model with parameters instead of configuration. The parameter model seems intuitive and I look forward to create new projects according to the server model.
The server model also introduces a new way of logging package execution and making the information accessible in SQL server either by querying procedures or using built-in reports and dashboards. This will most likely make the life a bit easier for the maintenance teams.
To summarize, I´m looking forward to the next version!