IDTSDesigntimeComponent90.Validate Method
Verifies that the component is correctly configured.
네임스페이스: Microsoft.SqlServer.Dts.Pipeline.Wrapper
어셈블리: Microsoft.SqlServer.DTSPipelineWrap (in microsoft.sqlserver.dtspipelinewrap.dll)
구문
‘선언
<DispIdAttribute(29)> _
Function Validate As DTSValidationStatus
[DispIdAttribute(29)]
DTSValidationStatus Validate ()
[DispIdAttribute(29)]
DTSValidationStatus Validate ()
/** @attribute DispIdAttribute(29) */
DTSValidationStatus Validate ()
DispIdAttribute(29)
function Validate () : DTSValidationStatus
반환 값
A value from the DTSValidationStatus enumeration that indicates the status of the component.
주의
The Validate method is implemented by component developers to verify that the component is correctly configured. It is called repeatedly during package design, and one time before execution of the component. Components should not modify its IDTSComponentMetaData90 during Validate.
Each component has different requirements for successful validation, but the following list provides some of the common items that should be validated.
Verify that the component has the expected number of IDTSInput90 and IDTSOutput90 objects.
Verify that any IDTSCustomProperty90 objects continue to exist and contain the correct values.
Verify that each IDTSInputColumn90 object in its IDTSInputColumnCollection90 references an existing IDTSOutputColumn90 object in an upstream component.
If the component uses a connection, verify that the IDTSRuntimeConnection90 is specified and that the ConnectionManager exists in the package.
Components should provide feedback to users when validation fails. Feedback is provided through the FireError and FireWarning methods and by the DTSValidationStatus return value. Calls to the FireError and FireWarning methods are displayed in the Task List window in Business Intelligence Development Studio, and should provide users guidance on the validation failure. Of the four values in the DTSValidationStatus enumeration, only VS_ISVALID indicates successful validation. The other three values indicate different levels of failure. The following table describes the failure values in the enumeration and how they are interpreted by SSIS Designer.
Status |
Description |
Indicates that the component is not configured correctly. The user must make changes to the ComponentMetaData to resolve the problems. |
|
Indicates that the validation errors can be fixed by the component in its implementation of the ReinitializeMetaData method. The SSIS designer will prompt users that the component can repair itself when the enumeration value is VS_NEEDSNEWMETADATA. Then the designer will call the ReinitializeMetaData method. |
|
Indicates that the ComponentMetaData is corrupted and cannot be repaired by a call to the ReinitializeMetaData method or by edits to the component. |
When the DelayValidation property of the data flow task is true, design-time calls to the Validate method are eliminated, and the method is called before component execution instead.
스레드 보안
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
IDTSDesigntimeComponent90 Interface
IDTSDesigntimeComponent90 Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace