Propriedade do RDL XMLTask.FailOnValidationFail
Gets or sets a Boolean that indicates whether the operation fails when a validation fails.
Namespace: Microsoft.SqlServer.Dts.Tasks.XMLTask
Assembly: Microsoft.SqlServer.XMLTask (em Microsoft.SqlServer.XMLTask.dll)
Sintaxe
'Declaração
Public Property FailOnValidationFail As Boolean
Get
Set
'Uso
Dim instance As XMLTask
Dim value As Boolean
value = instance.FailOnValidationFail
instance.FailOnValidationFail = value
public bool FailOnValidationFail { get; set; }
public:
virtual property bool FailOnValidationFail {
bool get () sealed;
void set (bool value) sealed;
}
abstract FailOnValidationFail : bool with get, set
override FailOnValidationFail : bool with get, set
final function get FailOnValidationFail () : boolean
final function set FailOnValidationFail (value : boolean)
Valor da propriedade
Tipo: System.Boolean
A Boolean that indicates whether the operation fails when a validation fails.
Implementa
IDTSXMLTask.FailOnValidationFail
Comentários
Default value is False. This property is used when the OperationType is set to Validate.
Exemplos
The following code example adds an XMLTask to a package, and sets properties using the TaskHost.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.XMLTask;
namespace XMLTask_API
{
class Program
{
static void Main(string[] args)
{
// Set up the objects and tasks.
Package pkg = new Package();
Executable exec1 = pkg.Executables.Add("STOCK:XMLTask");
TaskHost th = exec1 as TaskHost;
// You can cast the InnerObject to the XmlTask here.
// XMLTask myTask = th.InnerObject as XMLTask;
// Create a variable and a FILE connection manager to books.xml.
Variable resultVar = pkg.Variables.Add("resultVariable", false, "", "Variable for the result");
ConnectionManager connMgr = pkg.Connections.Add("FILE");
connMgr.Name = "XMLConnectionManager";
// The file, Books.xml, is stored on the C:\ drive.
connMgr.ConnectionString = @"c:\books.xml";
// Set the XMLTask properties.
// The first property to set is the OperationType. Depending on the
// OperationType, different properties are valid.
// The operation type in this example is VALIDATE.
th.Properties["OperationType"].SetValue(th, DTSXMLOperation.Validate);
th.Properties["SourceType"].SetValue(th, DTSXMLSourceType.FileConnection);
th.Properties["Source"].SetValue(th, connMgr.Name);
th.Properties["OverwriteDestination"].SetValue(th, true);
th.Properties["SaveOperationResult"].SetValue(th, true);
th.Properties["DestinationType"].SetValue(th, DTSXMLSaveResultTo.Variable);
th.Properties["Destination"].SetValue(th, resultVar.Name);
th.Properties["SecondOperandType"].SetValue(th, DTSXMLSourceType.DirectInput);
th.Properties["SecondOperand"].SetValue(th, "<x></x>");
th.Properties["ValidationType"].SetValue(th, DTSXMLValidationType.DTD);
th.Properties["FailOnValidationFaile"].SetValue(th, true);
DTSExecResult valResults = pkg.Validate(pkg.Connections, pkg.Variables, null, null);
Console.WriteLine("RESULTS: {0}", valResults);
}
}
}
Sample Output:
RESULTS: Success