If you’ve been following the pre-release versions SQL Server 2012 (previously code-named “Denali”) you’ve probably been using the Community Technology Preview (CTP3) that Microsoft released back in July. You probably have already seen the Release Candidate (RC0) that was made available last week.
But what you may not know is how SSIS is changed between CTP3 and RC0. RC0 is a big leap forward for SSIS, and includes some significant new functionality, such as:
- Script Component debugging
- Attunity Change Data Capture components
- Change Data Capture for Oracle
- ODBC Source and Destination components
- Externalize parameter values in Visual Studio configurations
- New REPLACENULL expression function
- UI for Pivot and Row Count transforms
- Tons of minor fixes and improvements based on CTP feedback
SSIS developer Matt Masson has a more in-depth look at these changes on the SSIS team blog, but I wanted to call them out here as well.
The final bullet is also worth stressing. You may not notice these improvements directly, but the SSIS team have made a significant “fit and polish” for RC0, improving functionality that was delivered in (and before) CTP3. If you’ve been using SSIS in CTP3, be sure to download RC0 today and give it a try.
 And to give credit where credit is due, the “what’s new” list in this post was blatantly copied from an email from Matt as well.
 Which I added to Matt’s list.