One of my favorite features of SQL 2005 is SSIS. It actually is usable (compared to it's old dumber brother DTS). One thing I have had the priviledge of working on is a component which Bruce mentioned on the newsgroups which allows SSIS and MSCRM to work together.
One of the worst points of the SSIS development is the error messages that SSIS throws back. Well there a place you can vote for actually providing some feedback to MS around pushing/advising them to help correct this. So go out and vote for better error messages and SSIS!!!