Share via

  • Article

XML Task Editor (General Page)

Use the General Node of the XML Task Editor dialog box to specify the operation type and configure the operation.

To learn about this task, see XML Task. For information about working with XML documents and data, see "Employing XML in the .NET Framework" in the MSDN Library.

Static Options

  • OperationType
    Select the operation type from the list. This property has the options listed in the following table.

    Value

    Description

    Validate

    Validates the XML document against a Document Type Definition (DTD) or XML Schema definition (XSD) schema. Selecting this option displays the dynamic options in section, Validate.

    XSLT

    Performs XSL transformations on XML documents. Selecting this option displays the dynamic options in section, XSLT.

    XPATH

    Performs XPath queries and evaluations. Selecting this option displays the dynamic options in section, XPATH.

    Merge

    Merges two XML documents. Selecting this option displays the dynamic options in section, Merge.

    Diff

    Compares two XML documents. Selecting this option displays the dynamic options in section, Diff.

    Patch

    Applies the output from the Diff operation to create a new document. Selecting this option displays the dynamic options in section, Patch.

  • SourceType
    Select the source type of the XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • Source
    If Source is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Document Source Editor dialog box.

    If Source is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If Source is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

OperationType Dynamic Options

OperationType = Validate

Specify options for the Validate operation.

  • SaveOperationResult
    Specify whether the XML task saves the output of the Validate operation.

  • OverwriteDestination
    Specify whether to overwrite the destination file or variable.

  • Destination
    Select an existing File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

  • DestinationType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • ValidationType
    Select the validation type. This property has the options listed in the following table.

    Value

    Description

    DTD

    Use a Document Type Definition (DTD).

    XSD

    Use an XML Schema definition (XSD) schema. Selecting this option displays the dynamic options in section, ValidationType.

  • FailOnValidationFail
    Specify whether the operation fails if the document fails to validate.

ValidationType Dynamic Options

ValidationType = XSD

  • SecondOperandType
    Select the source type of the second XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperand
    If SecondOperandType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Source Editor dialog box.

    If SecondOperandType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If XPathStringSourceType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

OperationType = XSLT

Specify options for the XSLT operation.

  • SaveOperationResult
    Specify whether the XML task saves the output of the XSLT operation.

  • OverwriteDestination
    Specify whether to overwrite the destination file or variable.

  • Destination
    If DestinationType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If DestinationType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

  • DestinationType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperandType
    Select the source type of the second XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperand
    If SecondOperandType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Source Editor dialog box.

    If SecondOperandType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If XPathStringSourceType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

OperationType = XPATH

Specify options for the XPath operation.

  • SaveOperationResult
    Specify whether the XML task saves the output of the XPath operation.

  • OverwriteDestination
    Specify whether to overwrite the destination file or variable.

  • Destination
    If DestinationType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If DestinationType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

  • DestinationType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperandType
    Select the source type of the second XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperand
    If SecondOperandType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Source Editor dialog box.

    If SecondOperandType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If XPathStringSourceType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

  • PutResultInOneNode
    Specify whether the result is written to a single node.

  • XPathOperation
    Select the XPath result type. This property has the options listed in the following table.

    Value

    Description

    Evaluation

    Returns the results of an XPath function.

    Node list

    Return the selected nodes as an XML fragment.

    Values

    Return the inner text value of all selected nodes, concatenated into a string.

OperationType = Merge

Specify options for the Merge operation.

  • XPathStringSourceType
    Select the source type of the XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • XPathStringSource
    If XPathStringSourceType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Document Source Editor dialog box.

    If XPathStringSourceType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If XPathStringSourceType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable

    When you use an XPath statement to identify the merge location in the source document, this statement is expected to return a single node. If the statement returns multiple nodes, only the first node is used. The contents of the second document are merged under the first node that the XPath query returns.

  • SaveOperationResult
    Specify whether the XML task saves the output of the Merge operation.

  • OverwriteDestination
    Specify whether to overwrite the destination file or variable.

  • Destination
    If DestinationType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If DestinationType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

  • DestinationType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperandType
    Select the destination type of the second XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperand
    If SecondOperandType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Document Source Editor dialog box.

    If SecondOperandType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If SecondOperandType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable

OperationType = Diff

Specify options for the Diff operation.

  • DiffAlgorithm
    Select the Diff algorithm to use when comparing documents. This property has the options listed in the following table.

    Value

    Description

    Auto

    Let the XML task determine whether to use the fast or precise algorithm.

    Fast

    Use a fast, but less precise Diff algorithm.

    Precise

    Use a precise Diff algorithm.

  • Diff Options
    Set the Diff options to apply to the Diff operation. The options are listed in the following table.

    Value

    Description

    IgnoreXMLDeclaration

    Specify whether to compare the XML declaration.

    IgnoreDTD

    Specify whether to ignore the document type definition (DTD).

    IgnoreWhite Spaces

    Specify whether to ignore differences in the amount of white space when comparing documents.

    IgnoreNamespaces

    Specify whether to compare the namespace uniform resource identifier (URI) of an element and its attribute names.

    NoteNote
    If this option is set to True, two elements that have the same local name but different namespaces are considered identical.

    IgnoreProcessingInstructions

    Specify whether to compare processing instructions.

    IgnoreOrderOf ChildElements

    Specify whether to compare the order of child elements.

    NoteNote
    If this option is set to True, child elements that differ only in their position in a list of siblings are considered identical.

    IgnoreComments

    Specify whether to compare comment nodes.

    IgnorePrefixes

    Specify whether to compare prefixes of element and attribute names.

    NoteNote
    If you set this option to True, two elements that have the same local name, but different namespace URIs and prefixes, are considered identical.

  • FailOnDifference
    Specify whether the task fails if the Diff operation fails.

  • SaveDiffGram
    Specify whether to save the comparison result, a DiffGram document.

  • SaveOperationResult
    Specify whether the XML task saves the output of the Diff operation.

  • OverwriteDestination
    Specify whether to overwrite the destination file or variable.

  • Destination
    If DestinationType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If DestinationType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

  • DestinationType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperandType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperand
    If SecondOperandType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Document Source Editor dialog box.

    If SecondOperandType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If SecondOperandType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable

OperationType = Patch

Specify options for the Patch operation.

  • SaveOperationResult
    Specify whether the XML task saves the output of the Patch operation.

  • OverwriteDestination
    Specify whether to overwrite the destination file or variable.

  • Destination
    If DestinationType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If DestinationType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable.

  • DestinationType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperandType
    Select the destination type of the XML document. This property has the options listed in the following table.

    Value

    Description

    Direct input

    Set the source to an XML document.

    File connection

    Select a file that contains the XML document.

    Variable

    Set the source to a variable that contains the XML document.

  • SecondOperand
    If SecondOperandType is set to Direct input, provide the XML code or click the ellipsis button (…) and then provide the XML by using the Document Source Editor dialog box.

    If SecondOperandType is set to File connection, select a File connection manager, or click <New connection...> to create a new connection manager.

    Related Topics:File Connection Manager, File Connection Manager Editor

    If SecondOperandType is set to Variable, select an existing variable, or click <New variable...> to create a new variable.

    Related Topics: Integration Services Variables, Add Variable