SSIS ForEach Variable Enumerator

SSIS ForEach Variable Enumerator 8

The SSIS Foreach Variable Enumerator is used to enumerate 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 … Read more

SSIS Foreach NodeList Enumerator

SSIS Foreach NodeList Enumerator 10

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

SSIS Foreach ADO.NET Schema Rowset Enumerator

SSIS Foreach ADO.NET Schema Rowset Enumerator 8

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