Share via

XML Task Editor (General Page)

  • Article

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.

  • 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.

  • 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.

  • 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

  • SaveOperationResult
    Specify whether the XML task saves the output of the Merge operation.
  • OverwriteDestination
    Specify whether to overwrite the destination file or 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

  • FailOnDifference
    Specify whether the task fails if the Diff operation fails.
  • SaveDiffGram
    Specify whether to save the comparison result, a DiffGram document.

  • DiffGramDestinationType
    If SaveDiffGram is True, select the destination type of the DiffGram 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.
  • SaveOperationResult
    Specify whether the XML task saves the output of the Diff operation.
  • OverwriteDestination
    Specify whether to overwrite the destination file or 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.

  • 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

See Also

Reference

Expressions Page

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance