Export (0) Print
Expand All

Validate Dialog Box

Use the Validate dialog box to check for common problems in Integration Services a project or package.

If there is a problem, a message is displayed at the top of the dialog box. Otherwise, the term Ready displays at the top.

  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 or package you want to validate.

  5. Right-click the package or package, and then click Validate.

Environment

Select the environment that you want to use to validate the project or package.

32-bit runtime

Select to use a 32-bit runtime to execute a package.

The Parameters tab lists the parameter values that you use to validate the project or package. The following are the options on the Parameters tab.

Container

Lists the object that contains the parameter.

Parameter

Lists the name of the parameters

Value

Lists the parameter value.

The Connection Managers tab lists the connection manager property values that you use to validate the project or package.

The following are the options on the Connection Managers tab.

Container

Lists the object that contains the connection manager.

Name

Lists the connection manager name.

Property name

Lists the name of the connection manager property.

Value

Lists the value assigned to the connection manager property.

Community Additions

ADD
Show:
© 2014 Microsoft