Export (0) Print
Expand All

Microsoft.SqlServer.Dts.Tasks.XMLTask Namespace

The Microsoft.SqlServer.Dts.Tasks.XMLTask namespace contains the interfaces and classes used for the XML Task, which is used to work with XML data. Using this task, a package can retrieve XML documents stored in files, apply operations to the documents using XSL Transformations, (XSLT) style sheets, and XPath expressions, merge multiple documents, and validate, compare, and save the updated documents to files and variables.

For more information, see XML Task.

  Class Description
Public class NamespaceDeclaration Declares the identifier and the prefix of a XML namespace by storing these string values as separate properties.
Public class NSCollectionEditor Represents the namespace collection editor.
Public class XmlDiffPerf Infrastructure. Represents a XmlDiffPerf class.
Public class XMLTask Contains the members used to run several XML tasks, depending on the OperationType property, which is a value from the DTSXMLOperation enumeration. This class cannot be inherited.

  Interface Description
Public interface IDTSXMLTask Infrastructure. Represents the DTS XML task.

  Enumeration Description
Public enumeration DTSXMLDiffAlgorithm Specifies which algorithm to use when comparing XML documents.
Public enumeration DTSXMLDiffOptions When the XMLTask has an OperationType set to Diff, then this enumeration is used to sets the options that affect the behavior of the comparison, as well as the resulting XDL DiffGram. The enumerations used will determine what items are included for consideration during the comparison.
Public enumeration DTSXMLOperation Specifies the operations used when working with XML documents.
Public enumeration DTSXMLSaveResultTo Describes the location where the results are saved. This enumeration is used to set the DestinationType property. Depending on value, the Destination property must be compatible. For example, if the destination type is set to Variable, then the destination property must provide a variable to save the results into. When the destination type is set to FileConnection, then the Destination property must provide a file connection manager.
Public enumeration DTSXMLSourceType Describes the location of the SourceType, the source type of the XPath string in XPathStringSourceType, and the type of the second operand in SecondOperandType. Depending on what the type is used, the Source, XPathStringSource, and SecondOperand properties must be compatible. For example, if the SourceType is set to FileConnection, then the Source must contain a connection manager. If the SourceType is Variable, then the Source must point to the variable to use.
Public enumeration DTSXMLValidationType 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.
Public enumeration DTSXMLXPathOperation Determines what type of XPATH functionality is performed. This enumeration is used by the XPathOperation.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft