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?
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.
In Object Explorer, expand the tree to display the Integration Services Catalogs node.
Expand the SSISDB node.
Expand the folder that contains the project or package you want to validate.
Right-click the package or package, and then click Validate.
Select the environment that you want to use to validate the project or package.
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.
Lists the object that contains the parameter.
Lists the name of the parameters
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.
Lists the object that contains the connection manager.
Lists the connection manager name.
Lists the name of the connection manager property.
Lists the value assigned to the connection manager property.