The SSIS Foreach Variable Enumerator enumerates the data inside a Variable. Use this enumerator to loop over the Object variable to get data from that object. For example, to iterate data coming from Arrays and Array Lists. This article shows, How to iterate Array List using SSIS Foreach Variable Enumerator and save data into the SQL Server table with … Read more
The SSIS Foreach NodeList Enumerator is useful to enumerate the XML nodes. For example, you can traverse to any node in an XML file using this enumerator. In this article, we will show you how to use this SSIS Foreach NodeList Enumerator with an example. Before we start demonstrating the Foreach NodeList Enumerator in SSIS, Let … Read more
The SSIS Foreach ADO.NET Schema Rowset Enumerator is used to enumerate the SQL Server Objects. For example, you can use this SSIS Foreach ADO.NET Schema Rowset to loop over the Views, Schema, Tables, Indexes, Constraints, etc., present in a Database. In this article, we will show how to find the Views in a SQL Server … Read more
