You have a Microsoft SQL Server Integration Services (SSIS) package that includes the control flow shown in the following diagram.

You need to choose the enumerator for the Foreach Loop container.

Which enumerator should you use?

A. Foreach SMO Enumerator

B. Foreach ADO.Net Schema Rowset Enumerator

C. Foreach NodeList Enumerator

D. Foreach ADO Enumerator

Explanation:

Use the Foreach ADO enumerator to enumerate rows in tables. For example, you can get the rows in an ADO recordset.

References: https://docs.microsoft.com/en-us/sql/integration-services/control-flow/foreach-loop-container?view=sql-server-2017