SSIS For Each Nodelist Enumerator

  • Recently i added a topic with the question about finding the user defined variables in a package without knowing the name. I got the solution for that problem and it works....

    With the for each nodelist enumerator i make a file connection with the dtsx files and with the Xpath configuration it is possible. The problem is that i have a query that writes all the attributes of a dtsx file into a table. There are a lot of attributes in a dtsx package:

    XPATH

    EnumarationType : NodeText

    OuterXPathStringSourceType : DirectInput

    OuterXpathString : //attribute::*

    Any other XPath setting will result in a empty resultset.

    I need to change the Xpath query but i don't know how. Help!!!

    :hehe:

  • You need to set the OuterXPathString to the node you want to read.

    Example:

    GroupList>

    group>1 /group>

    group>2 /group>

    /GroupList>

    Had to remove the begin brackets for it to show.

    Your xpath will be //group

    You loop will find 1 and 2

    Hope this helps.

    Mike Davis

    Pragmaticworks.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply