The XML Component Target Settings dialog box allows you to configure
your XML target including, creating document breaks, defining repeating
nodes, creating node breaks, and configuring output options.
Configure the target component options
Do one of the following:
If you just created an XML target connection, click the Connection tab, then click Adapter Settings.
To open the XML Target Component Settings dialog box from an existing DTS:
From the Connection Manager, select an XML target connection and
click Edit.
Click the Connection tab.
Click Adapter Settings.
View or change the following options:
File Connection — Displays the location of the Output
data and Schema used by this connection.
Document Break — Select a field or action from the
drop-down list that will cause Insight to create a new document whenever
the break occurs.
Select Repeating Nodes — Define one or more repeating
nodes. To indicate a repeating node, highlight the node and then select
the Repeating Node check box, or right-click the
node and select Repeating Node. A double arrow
icon appears next to the node to indicate that it is a repeating node.
Note: Multiple repeating nodes must relate in a linear fashion to existing
repeating nodes. That is, a new repeating node must be a grandparent, parent, or
child of an existing repeating node. See
Source
Side Component Settings for an example of a repeating node.
Node Break — Select one or more fields that creates
a new node whenever there are changes to the selected field(s). The Node
Break area is inactive until you select a repeating node.
Include Schema References — Include the schema
references you specified in the Target Connection Wizard (Select the
Schema on which to base the target document).
Format Output for text viewing — Format the output
XML document for easy editing in an external editor (such as Notepad).
Note: The Format Output for text viewing option may increase processing
time.
XML Encoding -Select the appropriate encoding from
the drop-down list to ensure that XML documents properly transfer between
different platforms. Encoding is similar to character sets. Alternatively,
you can type additional character sets that are supported by your system.
Maximum Records Per Document — Specify the number of
source records to write to the target before the target document is written.
For example, if you specify "5", then a new document is written after each
set of 5 records. Default setting is 0, which writes a new document containing all records.
Comments — Add a comment to be output at the beginning
of the XML file.