ScriptTask.Validate Method

Verifies that the component is correctly configured.

Namespace:  Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly:  Microsoft.SqlServer.ScriptTask (in Microsoft.SqlServer.ScriptTask.dll)

Syntax

'Declaration
Public Overrides Function Validate ( _
    connections As Connections, _
    variableDispenser As VariableDispenser, _
    events As IDTSComponentEvents, _
    log As IDTSLogging _
) As DTSExecResult
'Usage
Dim instance As ScriptTask
Dim connections As Connections
Dim variableDispenser As VariableDispenser
Dim events As IDTSComponentEvents
Dim log As IDTSLogging
Dim returnValue As DTSExecResult

returnValue = instance.Validate(connections, _
    variableDispenser, events, log)

public override DTSExecResult Validate(
    Connections connections,
    VariableDispenser variableDispenser,
    IDTSComponentEvents events,
    IDTSLogging log
)

public:
virtual DTSExecResult Validate(
    Connections^ connections, 
    VariableDispenser^ variableDispenser, 
    IDTSComponentEvents^ events, 
    IDTSLogging^ log
) override

abstract Validate : 
        connections:Connections * 
        variableDispenser:VariableDispenser * 
        events:IDTSComponentEvents * 
        log:IDTSLogging -> DTSExecResult 
override Validate : 
        connections:Connections * 
        variableDispenser:VariableDispenser * 
        events:IDTSComponentEvents * 
        log:IDTSLogging -> DTSExecResult 

public override function Validate(
    connections : Connections, 
    variableDispenser : VariableDispenser, 
    events : IDTSComponentEvents, 
    log : IDTSLogging
) : DTSExecResult

Parameters

• connections
  Type: Microsoft.SqlServer.Dts.Runtime.Connections
  A collection of connections used by the task.

• variableDispenser
  Type: Microsoft.SqlServer.Dts.Runtime.VariableDispenser
  A T:Microsoft.SqlServer.Dts.Runtime.VariableDispenser object for locking variables.

• events
  Type: Microsoft.SqlServer.Dts.Runtime.IDTSComponentEvents
  An object that implements the T:Microsoft.SqlServer.Dts.Runtime.IDTSComponentEvents interface.

• log
  Type: Microsoft.SqlServer.Dts.Runtime.IDTSLogging
  An object that implements the T:Microsoft.SqlServer.Dts.Runtime.IDTSLogging interface.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.DTSExecResult
A value from the DTSExecResult enumeration.

Remarks

The Validate method reviews properties and settings for inaccuracies or incorrect settings. The method does not examine data, or connect to data sources to validate connections. However, using the method ensures that required fields are populated and contain appropriate values. The fields that are validated differ depending on the object that is being validated.

See Also

Reference

ScriptTask Class

Microsoft.SqlServer.Dts.Tasks.ScriptTask Namespace