Export (0) Print
Expand All

Project Properties Dialog Box

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.

  1. 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.

  2. In Object Explorer, expand the tree to display the Integration Services Catalogs node.

  3. Expand the SSISDB node.

  4. Expand the folder that contains the project that you want to set properties for.

  5. Right-click the project, and then click Properties.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft