Export (0) Print
Expand All
Expand Minimize

DTSValidationStatus Enumeration

Specifies the return value of a call to Validate.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

public enum DTSValidationStatus

Member nameDescription
VS_ISBROKENThe component is incorrectly configured; typically, this indicates that a property is set incorrectly.
VS_ISCORRUPTThe component is irreparably damaged and must be completely reset. The designer calls the component's ProvideComponentProperties method in response.
VS_ISVALIDThe component is correctly configured and ready for execution.
VS_NEEDSNEWMETADATAThe component's metadata is outdated or corrupt, and a call to ReinitializeMetaData will repair the component.

A data flow component returns a value from this enumeration in the Validate method that indicates its readiness to execute. VS_ISVALID is the only success value contained in the enumeration and indicates that the component is properly configured, has no errors, and is ready to execute.

The other three values indicate failure. For example, VS_NEEDSNEWMETADATA indicates that errors have occurred that can be repaired by the ReinitializeMetaData method. The specific value returned by a component is not visible in the designer, rather, a component raises information about the failure using the FireError, FireWarning, and FireInformation methods of the IDTSComponentMetaData100 class.

Community Additions

© 2014 Microsoft