catalog.validate_project (SSISDB Database)
Asynchronously validates a project in the Integration Services catalog.
validate_project [ @folder_name = ] folder_name , [ @project_name = ] project_name , [ @validate_type = ] validate_type , [ @validation_id = ] validation_id OUTPUT [ , [ @use32bitruntime = ] use32bitruntime ] [ , [ @target_environment = ] target_environment ] [ , [ @reference_id = ] reference_id ]
The following list provides some conditions that may raise an error or warning:
Validation fails for one or more packages in the project
Validation fails if one or more of the referenced environments included in the validation do not contain referenced variables
The specified validate type is not valid
The project name or environment reference ID is not valid
The user does not have the appropriate permissions
Only environments that are accessible by the user can be used in the validation. Validation output is sent to the client as a result set.
In this release, project validation does not support dependency validation.
Full validation confirms that all referenced environment variables are found within the referenced environments that were included in the validation. Full validation results list environment references that are not valid and referenced environment variables that could not be found in any of the referenced environments that were included in the validation.