Can someone point me to a good source for Best Practices for managing SSIS package security in SQL Server 2008 R2? In specific, I have many SSIS packages that perform tasks for various departments in the company. They all run fine under my login and I have always run them as needed, but I want to put them into jobs or delegate the ability to run them to others. What's the best way to manage the required DB permissions, etc. if I want to get me credentials cleared out?
- Richard Ray Jackson Hole Mountain Resort
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.