Thank you Mr. Jones, that is one approach.

It’s not a matter of they don't what to grant the permission. If there is a way to grant the "read only" permission, they would be more than happy...

Thanks for your reply Roy. Albeit, not helpful. We have a small DBA shop that is overworked that is supporting a huge migration to 2005. Being a...

Teri,

I'm sorry, but short of creating an app to do this, I don't think there is a good solution. And this app would have to be executed by a...

We use RSScripter as well.  It is a great tool for deploying reports from one folder to another or to another server.  And best of all, you don't have to...

Thanks for the reply Greg.  That is what I figured, but I wanted to make sure.

Michael,

Thank you for your reply.  Actually, this is a little different than Windows logins.  We are using AD accounts to create SQL Credentials to create SQL Proxies...

PStair,

We are going the route of storing the SSIS packages on the file system rather in SQL Server.  We are slowly getting our 2005 environments up and we just recently...

Jeff,

Thanks for your reply.  I noticed this too and put a distinct where you mentioned.  Thanks again for the replies folks!

Lynn, you rock!  Thank you so much!

Thanks and congratulations SQL Server Central .  This is by far one of the best resources on the Net for information.  The number...

I didn't think the Run As allows things other than Proxy accounts.

Okay, I have a little more on this.  Please correct me if I'm wrong on this.

I create a domain account that has rights to the resources it needs (file shares,...

Again, thank you for the quick reply.  I will look into this.

Lee

Thank you for your reply.  Can you point me in the direction of how to do this?  My research has turned up nothing so far.  Also, I would assume when...