I take it that your reports and SSIS use stored procs to encapsulate the logic?
Do you use Visual Studio (VS2008 GDR/VS2010 Premium) database projects for storing your Database code? Or a different tool?
_________________________________________________________________________
SSC Guide to Posting and Best Practices