Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
XML Task Editor (General Page)
Collapse the table of content
Expand the table of content

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.

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 (SSIS) Variables, Add Variable.

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.

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 (SSIS) Variables, Add Variable.

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 (SSIS) 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 (SSIS) Variables, Add Variable.

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 (SSIS) 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 (SSIS) 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.

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 (SSIS) 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 (SSIS) 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 (SSIS) Variables, Add Variable

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.

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

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

System_CAPS_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 (SSIS) 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 (SSIS) Variables, Add Variable

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 (SSIS) 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 (SSIS) Variables, Add Variable

Community Additions

ADD
Show:
© 2015 Microsoft