The project I'm currently working on relies heavily on integration (as most of our work does).
This means, I now get to play with SSIS (SQL Server 2005 Integration Services), Microsoft's answer to all your ETL needs. I've only dabbled with a couple of examples, but can say, that I am cautiously optimistic at present.
On-line resources were annoying me (too much yabbing, too few examples/detailed explanations), so we got a really fab book on SSIS - "Professional SQL Server 2005 Integration Services" with loads of practical examples and how tos. Highly recommended!!