Wonderful! In meeting just yesterday expressing the same type requirements for a DR tracking application. I also have been using RS and now SSRS since it came out. We are very interested...
8 Servers/ 5 are production with 11 instances not counting development VM's. About to add 1 more server and 3 more instances for 2005 conversions. Also support 6 instances of Reporting...
Great overview. What I find the most confusing with SSIS is the new package security, encryption options, storage options, migration of packages, etc. Any good resources on that?
But if you want SQL Agent job and error notifications you have to manually script the jobs and change them to use the smtp dll. We use both because smtp...