Tips
Get Active Directory Users and Groups with SQL Server Integration Services
We have a requirement to implement security in our data warehouse to limit what data a user can see on a report. As an initial step we have created tables for users and roles we also have a user role table where we specify the role(s) a user is assigned. We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
Securing Your SSIS Packages Using Package Protection Level
I've noticed that SSIS packages have a property called ProtectionLevel with several possible values. Can you provide an explanation of the available options and examples of how they are used? In this tip we take a look at each of these protection levels and how they can be used.
Top 10
Get Active Directory Users and Groups with SQL Server Integration Services
We have a requirement to implement security in our data warehouse to limit what data a user can see on a report. As an initial step we have created tables for users and roles we also have a user role table where we specify the role(s) a user is assigned. We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
Securing Your SSIS Packages Using Package Protection Level
I've noticed that SSIS packages have a property called ProtectionLevel with several possible values. Can you provide an explanation of the available options and examples of how they are used? In this tip we take a look at each of these protection levels and how they can be used.
Last 10
Securing Your SSIS Packages Using Package Protection Level
I've noticed that SSIS packages have a property called ProtectionLevel with several possible values. Can you provide an explanation of the available options and examples of how they are used? In this tip we take a look at each of these protection levels and how they can be used.
Get Active Directory Users and Groups with SQL Server Integration Services
We have a requirement to implement security in our data warehouse to limit what data a user can see on a report. As an initial step we have created tables for users and roles we also have a user role table where we specify the role(s) a user is assigned. We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
