I have had nothing but frustration with MOSS 2007 SP2 + SharePoint Reporting Services + SQL 2005 SP2. I even followed Raju Sakthivel's guide for SharePoint Integration Mode, but I cannot publish a model. 

Is it worth integrating it?