The SQL Server 2005 Tools were actually a path I started down Friday, Having privilege issues getting it installed on the server, but it appears to be able to accomplish...

Thank you both for the responses, we now have a fairly complex model developed.  One thing we have not been able to get working though is security.  We want to use...

I believe you can just type in the server you want to connect to.  I don't ever use the drop down in server name we have to many it takes...

When you deploy your package... make sure to click the checkbox that says depend on server for security.  You're losing your password because of the security settings on the package.

You...

Thank you Daniel.  Even after reading your explination it took me a while to find it.  Talk about hidden!

But it's working beautifully.

Ches

Thank you Steve.  I added a join to the user preference table to narrow down the results and it's working beautifully.  I had hoped that somehow the PIVOT option in...

Sure. If someone had the UK set as their preference they'd get this....

Thank you Wanderer, I look forward to seeing it.

I've been toying with getting one of our app guys to write a web service that checks for their file, ftp's and...

Six years ago we had 7 with 20 or so databases.  Today.  more like 300 production servers with a couple thousand databases, and an untold number of dev servers/databases (including...