1 out of 1 rated this helpful - Rate this topic

Assign a Reader and Writer Role to a Package

SQL Server 2012

You can assign a reader and a writer role to each package.

In Object Explorer, locate the Integration Services connection.
Expand the Stored Packages folder, and then expand the subfolder that contains the package to which you want to assign roles.
Right-click the package to which you want to assign roles.
In the Packages Roles dialog box, select a reader role in the Reader Role list and a writer role in the Writer Role list.
Click OK.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions