ok thanks for the reply 🙂

"First of all, you run a script to find Contractor and Expense tables across all databases on you production server"

sorry if I am wrong, but why are you searching all...

I agree with the seperate server to do whatever instead of touching the production server. Actually we did the same thing. We port data from Oracle production database to dedicated...

makes sense 🙂 thanks for the reply.

nice one.. but why do you need this.. cant we just use email notification when jobs fail and use SSMS - job activity monitor to monitor jobs.

Nice tips.. another quick option is to open the Packages in EDITPLUS and do a quick find+replace in "all open files" 🙂

yes like most people said using package config...

I would just use the SUB TOTAL for that person grouping or use INSCOPE function.

http://munishbansal.wordpress.com/2008/12/23/customizing-subtotal-functionalityusing-inscope-function-in-matrix-reports-ssrs/

do a BEGIN TRAN & COMMIT TRAN in SSMS. it sounds silly but it may work.

I would try deleting the .data file and closing BIDS and SSMS and reopening and hitting refresh button on the data or preview tab.