You can see all of this information on MSDN in the SP2 Readme , but I thought I'd highlight a couple of things.
Diagnostic Logging
A lot of trace logging was added in SP2 to help with debugging connectivity issues. These messages are logged using...

A post in the forums had me try out what turned to be a dangerous combination of flags in the Transfer SQL Objects task. The user said they were no longer able to access their database after running their package, and I was curious as to why this would...