DTSXMLValidationType Enumeration
Specifies the type of validation that the operation uses. This enumeration is only used when the OperationType is Validate. The default is an XML Schema, which is a value of XSD.
Assembly: Microsoft.SqlServer.XMLTask (in Microsoft.SqlServer.XMLTask.dll)
| Member name | Description | |
|---|---|---|
| DTD | Specifies that the validating parser is to retrieve the document type definition (DTD) and ensure that the document conforms to the grammar that the DTD describes. | |
| XSD | Default. Specifies that the document is validated by using the XML Schema validation services. |
The following code example shows this enumeration being used to set the ValidationType for the task.
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, // but it is advised that you work with tasks // through the TaskHost and its Properties. // 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 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
Show: