This topic has not yet been rated - Rate this topic

Project Properties Dialog Box

SQL Server 2012

An Integration Services project is a unit of deployment. Each project can contain packages, parameters, and environment references. A project is a securable object and can define permissions for database principals. When a project is re-deployed, the previous version of the project can be stored in the Integration Services catalog.

Project parameters and package parameters can be used to assign values to properties within packages at the time of execution. Some parameters require values before the package can be executed. Parameter values that reference environment variables require that the project has the corresponding environment reference prior to execution.

What do you want to do?

Open the Project Properties dialog box
Set the options on the General page
Set the options on the Permissions page

Open the Project Properties dialog box

In SQL Server Management Studio, connect to the Integration Services server.

You’re connecting to the instance of the SQL Server Database Engine that hosts the SSISDB database.
In Object Explorer, expand the tree to display the Integration Services Catalogs node.
Expand the SSISDB node.
Expand the folder that contains the project that you want to set properties for.
Right-click the project, and then click Properties.

Set the options on the General page

Use the General page to view project properties.

Name: Lists the project name.
Identifier: Lists the project ID.
Description: Displays the optional description of the project.
Project Version: Lists the project version.
Deployment Date: Lists the date and time the project was deployed or redeployed.

Set the options on the Permissions page

Use the Permissions page to view and set explicit permissions for the project.

Browse: Click Browse to select users and roles that you want to set permissions for, by using the Browse All Principals dialog box.
Name: Lists the name of the user or role.
Type: Lists the type of user or role.
Permission: Lists the permissions.
Grantor: Lists the user or role that grants the permission.
Grant: When Grant is selected, the permission is granted for the selected user or role.
Deny: When Deny is selected, the permission is denied for the selected user or role.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD