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.
- Create a variable for every attribute, use the string data type (change later in data flow if need be)
- 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.