There are some good blogs kicking around - these are the ones that I've had a few hints and tips from and that have been added to my RSS aggregator:
- Kirk Haselden
- Jamie Thomson - especially the SSIS: Suggested Best Practices and naming conventions
- Daniel Read who amongst his other helpful posts has put together an index to the excellent SQL 2005 SSIS How to series by Marcin Policht at Database Journal.
- Professional SQL Server 2005 Integration Services is a bit basic and doesn't really go into any of the more complex bits and pieces. An alright introduction, but to be honest some of the web sites mentioned above can give you that level of information.
- Microsoft SQL Server 2005 Integration Services. On order, not released until end of August 2006.
Futher Update: Thanks to Linda for pointing out via Daniel Read's index that there is an index to the SSIS articles on Database Journal.