Denali CTP 1: What’s new in SSIS?

In short: A lot.

The first Community Technology Preview (CTP) of the next SQL Server version was made available to the general public last week during PASS Summit. I am very excited about some of the changes coming from the BI side of the product, especially from the SSIS side. After seeing some of the demos at the PASS Summit, and playing around with the tool, I tend to group the changes in 3 major areas:

• Developer Experience – Usability
• SSIS Parameters
• Deployment – A new model
• SSIS Server – A new Server

I will cover changes in these areas in more detail in subsequent posts. But in the mean time you can use the following links if you want to read more - or even play with it:

Denali Resource center (download, videos, sample DB, etc.):
http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx
Microsoft TechNet Wiki:
http://social.technet.microsoft.com/wiki/contents/articles/tags/Integration+Services/default.aspx
Denali Books on Line
http://msdn.microsoft.com/en-us/library/ms141026(v=SQL.110).aspx


Happy CTP!