SSIS ForEach Loop SMO Enumerator

In this article, we will show you the steps involved in configuring the SSIS ForEach Loop SMO Enumerator. SSIS ForEach Loop SMO Enumerator: SMO means SQL Server Management Object, which is used to enumerate SQL Server Management Objects. For example, the SSIS ForEach Loop SMO Enumerator can enumerate the list of tables, Views, etc., present in the Database. … Read more

SSIS ForEach Loop File Enumerator

The SSIS ForEach Loop container will repeat the control flow task for N number of times, similar to the Foreach loop in any programming language. The SQL Server Integration Services provides eight types of enumerators. This article will show you the steps in configuring the SSIS ForEach Loop File Enumerator. It is used to enumerate … Read more