Int he most recent TechNet Flash newsletter, I spied a link to the article How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007. The article mentions the need to update instances of Notification Services. Following the instructions at http://support.microsoft.com/kb/931815/ was relatively painless.
In addition, there are some issues when using the DateAdd and DateDiff functions. The recommended fix is to use GetUtcDate instead of GetDate. I checkes the apps and DTS packages I have written and none were affected.