I'm stunned by the amount of effort required to use SSIS to push data out. Underneath it is simply a connection string, a sql statement, a destination, and some amount of access security. If to a centralized destination, perhaps web-centric, a pull solution like snelmica recommends has a lot of appeal. Presumably the sql is a proc opening up all sorts of tailored-to-user role features, including whether report is ever even used. The game can be abstracted, as your mentor would do, to a system for creating destination files where most of the added value is the sql statement, not the SSIS. Manufacture an excel file or cut and paste into a killer excel template, then copy to your favorite central location - even Share Point, if you must.