SSIS Tip – Xpath for Root Level Attributes (XML Tasks)

Posted on Mar 3, 2011 in Technical Tips | 0 comments



For some reason, SSIS’s XML Data source does not allow you to directly access root level attributes. Therefore, we’ve got to use a XML Task and variables in order to pull this data in.

  1. Create a variable for every attribute, use the string data type (change later in data flow if need be)
  2. Use the following example (fill your own Xpath in the Second Operand)

This example will only pull in one value. Should there be multiple attributes with the same name, you’ll have to use a Foreach loop.

Bookmark and Share

Related Information:

  1. SSIS Tip – Xpath from a C# Script Task
    At some point you may...
  2. Request XML from URL in SSIS C# Script Task
    Occasionally, I’ve needed to pull...
  3. SSIS Tip – Read from Variables to Rows in Data Flow using Script Task
    Reading from variables to augment...
  4. SSIS Tip – Save Package to MS SQL Server (Integration Services)
    In order to save your...
  5. Oracle AS: Undeploying Multiple Applications (including BPEL Human Tasks)
    Undeploying a single application in...

Leave a Reply