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.
What do you want to do?
|
Open the Validate dialog box
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.
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 parametersValue
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.