XML Task

Whenever you are working with XML data, you will be most likely using the XML task to perform operations on the XML documents. This task is designed to work with the XML documents from the workflow point of view, whereas if you want to bring XML data in the data flow to apply transformations, you will be using the XML Source adapter while configuring your Data Flow task. The XML Source adapter is available in the Data Flow Sources section in Toolbox when you’re working with the Data Flow task on the Data Flow panel.

Using the XML task, you can perform the following operations on XML documents:

  1. Retrieve XML documents and dynamically modify those documents at run-time.

  2. Select a segment of the data from the XML document using XPath expressions ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.