You are here:

Source Side Component Settings

If you just created an XML source connection, the Connection Settings dialog box opens. If necessary, click the Connection tab and then click Adapter Settings.
To open the XML Source Component Settings dialog box from an existing DTS:
1. From the Connection Manager, select an XML target connection and click Edit.
2. Open the Connection tab.
3. Click Adapter Settings.

Use the XML Component Source Settings dialog box to:

View the file locations of the schema and data you are using
Define one or more repeating nodes.
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.

Defining Repeating Nodes

From the Select Repeating Node(s) text box, highlight the node you want to define as repeating.
Do one of the following:
- Select the Repeating Node check box
- Right-click the node, and then select Repeating Node.
  A double arrow icon appears next to the node to indicate that it is a repeating node.

Repeating Nodes Limitation

While the XML component does support repeating nodes, it does not support repeating sibling nodes. For example in the following diagram, there may be many customers with multiple addresses and phone numbers. While you can specify Customer and Address as repeating nodes, you cannot also specify Phone Info as repeating, because Address and Phone Info are siblings.

Customers

--Customer

----Name

----Addresses

--------Address

------------Street

------------City

------------State

------------Zip

----Phone Numbers

--------Phone Info

------------Number

------------Type