SSIS For Each Nodelist Enumerator

• Jacobus-785651

  Ten Centuries

  Points: 1106

  More actions

  November 17, 2008 at 1:30 am

  #94694

  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:

• magic2c

  Valued Member

  Points: 71

  More actions

  December 11, 2008 at 4:10 pm

  #911388

  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