how do we provide security to the packages ssis?
Hi Could you please tell me how to provide security to the packages in SSIS?
July 10th, 2011 12:42pm
security has two parts in SSIS;
Securing the content of package, which can be applied with ProtectionLevel;read more about protection level here:
http://msdn.microsoft.com/en-us/library/ms141747.aspx
Permissions on run and edit /delete/export /import packages , which you can use built-in sql server roles to apply permissions on packages, as below:
http://msdn.microsoft.com/en-us/library/ms141053.aspxhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2011 2:55pm