So, on to day 2 of SQL Pass, and a very SSIS focused one – mainly because I attended Matt Masson’s SSIS session and learned about a whole new bunch of nice features that have made it in to the next version.
I took away the following interesting points from that session:
- CDC (Change Data Capture) is supported more effectively through some new components – a CDC Control, CDC Source and CDC Splitter
- ODBC improvements mean improved performance for non SQL Server databases
- Connection Managers get a few new features – Offline, Expression and Project indicators. Also Offline Connection Managers are picked out through a timeout and importantly now halt validation of any related components (so you no longer get those drags as SSIS tries to validate components and flows hooked to dead connections)
- File Connection Manager can now handle variable numbers of columns (i.e. it won’t crash)
- Pivot gets a UI – hurrah! (Note: SCD still sucks)
- Project Parameters can be configured at design time though Visual Studio Configurations
- Breakpoints are now in the Script Component so we can see what data is causing or components to blow up
- Data Taps – data viewers for live execution that dump out to .csv files
- Package Execution via PowerShell or even T-SQL!
Matt also gave a preview of Barcelona in action, and it looks pretty neat.
I also attended a DQS session that showed a few new features on the UI. Elad Ziklik highlighted that the CTP3 release should be viewed more as a capability preview rather than a test drive of a functional product – so looking forward to a new CTP.
One more day down – one to go…!