TechNet
Export (0) Print
Expand All

Validate Dialog Box

 

Applies To: SQL Server 2016

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?

  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:
© 2016 Microsoft