Validate Dialog Box

  • Article

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.

What do you want to do?

  • Open the Validate dialog box

  • Set the options on the General page

Open the Validate dialog box

  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.

Set the options on the General page

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