TechNet
Export (0) Print
Expand All

Project Properties Dialog Box

 

Applies To: SQL Server 2016

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?

  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.

Community Additions

ADD
Show:
© 2016 Microsoft