Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 package roles and permissions

Author  Topic 

varalakshmi
Yak Posting Veteran

98 Posts

Posted - 2008-01-02 : 02:05:34
Hi,
How to set permissions for users to run or edit packages?
How to notify the changes made to packages and where to find the change notifications?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-02 : 04:26:03
for 1st qn. Check this. Might be of help:-

[url]http://technet.microsoft.com/en-us/library/ms141747.aspx[/url]
[url]http://technet.microsoft.com/en-us/library/ms141053.aspx[/url]

For notifying changes, you can document the change history on each packages using text annotations. To add a text annotation, open a pckage in BI studio, right click and select Add new text annotation.
Go to Top of Page
   

- Advertisement -