home  »  Blogs  »  MikeDavis  »  For Each Node List Enumerator SSIS

For Each Node List Enumerator SSIS

change text size: A A A

posted 11/12/2009 by MikeDavis

To use the For Each NodeList Enumerator in SSIS we will need to point the connection to an XML file then set the OuterXPathString. This will be the name of the Node will two slashes in front. I downloaded an XML file from W3Schools.com and use it my example. It is an XML with many plan types and information about plants. One of the nodes is COMMON. To pull all of the nodes from the list we use a For Each Loop and set the OuterXPathString to  //COMMON. We can set a breakpoint on the loop and use a watch window to see the value of the variables(Debug>Windows>Watch, only during Debug).

For Each Node
For Each Node

We will see each of the values for Common change as we continue through the breakpoints. I set the breakpoint to each iteration of the loop. You can then save the value in a variable under variable mappings in the For Each Loop.

tags: For Each Node List Enumerator SSIS
To rate this blog entry please  register or login

Author

MikeDavis MikeDavis (Member since: 10/27/2009)
Mike Davis, MCTS, Senior Business Intelligence Consultant and Trainer at Pragmatic Works. He is an author on Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups across the US, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

View MikeDavis 's profile

Comments (no comments yet)

Post a comment

Comment (No HTML)  

Type the characters:
 *
 
   

Join Business Intelligence Developer Network for FREE Today!

It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.

enter your email address:

MikeDavis's latest blog posts

  • SSIS Renaming and Moving Tasks
    3/4/2010
    If you are like me you click the mouse a lot, and fast. I drive my mouse to the breaking point clicking around so fast on items, especially in SSIS, which is a graphical interface. But when clicking on the tasks in SSIS I sometimes end up in the rename fu...
  • SSIS Excute SQL Task Fails with Executing the Query " " Failed
    3/2/2010
    When running a package with an execute SQL Task it is easy to get syntax errors. If the tasks turns red, but still accomplished its work, like an insert statement and the error you recieve is: Executing the Query " " Failed ...  This is saying the query w...
  • SSRS 2008 Report Model with no Foreign Key and/or primary Key
    2/26/2010
    When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, One with first names, the second with last names. Ea...
  • SSRS 2008 Change the Series Colors for Chart and Legend
    2/25/2010
    In my last SSRS 2008 class I was showing the students the chart tools and used color as a series on a chart. It was the product color column from the AdventureWorks 2008 Production.Product table. The series automatically chooses colors based on the ...
  • SSRS Expressions MTD Month to Date
    2/24/2010
    If you have a report in SQL server reporting services that has start and end date parameters, you may want to have default dates to show the current month to date. The end date is easy, it is just the today() function. The start date needs to get the firs...

Latest community blog posts

  • MikeMollenhour Using Temp Tables in Data Flow Source Stored Procedure
    3/11/2010
    Many times while working with SSIS I have had issues where I would like to add a temp table to a stored procedure that is a source for my SSIS dataflow. One work around for this is create a temp table variable instead. The issue with this is if many rows ...
  • BradSchacht SQL REPLACE for editing Configuration Tables
    3/10/2010
    Package Configurations in SSIS are key to making your packaged portable across the entire development process.  The problem you being to face with configuration files is the quantity that you collect.  Recently I was working on a project where we had paca...
  • BradSchacht Calculate the Date of the Previous Sunday
    3/10/2010
    There are a number of ways that you can calculate dates using T-SQL.  A common practice is to find the first day of the week which can be accomplished easily by using the following function.select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)However, you will ...
  • Bevans Back to Basics
    3/10/2010
    Today I figured I go back to basics with this blog since a majority of the visitors to this site are primarily DBA's and Database Guru's. This may turn into a series but for now we will discuss a bit of a feared power of sql server, and that is the fact t...
  • PatrickLeBlanc Using a CTE with a T-SQL Pivot Statement
    3/9/2010
    During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE).  In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the deri...