Update below
Another issue with SSIS SP1 has come to light that people need to be aware of. This one is in relation to the SSIS service not starting.
Here's the error that you may get:
"The SQL Server Integration Services service failed to start due to the
following error: The service did not respond to the start or control request
in a timely fashion"
The mercurial Michael Entin from the SSIS dev team has come up with the explanation and fix. Upon startup the SSIS service tries to validate an assembly signature which involves it trying to access a Certificate Revocation List on the internet. If the service cannot access the internet (perfectly acceptable in a data centre methinks) then the service will fail to start.
You can disable this attempt to access the internet, per user, in IE options --> Advanced --> Security-->Check for server certificate revocation (requires restart).
If you are running the SSIS service under a network service account then you cannot launch IE under this user account so you need to clone registry value 'State' from
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\WinTrust\Tru
st Providers\Software Publishing
to
HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\CurrentVersion\WinTrust\T
rust Providers\Software Publishing
Read more about this problem here: http://groups.google.co.uk/group/microsoft.public.sqlserver.server/browse_frm/thread/f6f493a81d897aac/c98b27a44e1d36c1?lnk=raot#c98b27a44e1d36c1
Great work Michael!
-Jamie
UPDATE 2006-04-27: Yet more SP1 specific information here from Darren Green: http://wiki.sqlis.com/default.aspx/SQLISWiki/SP1.html