Missing Enumerator in Foreach Loop Editor

Question

I'm on a new laptop, working in Visual Studio 2015 on a SQL Server Integration Services package.

In previous versions of Visual Studio there are several options in the Enumerator configuration section, like this...

In VS 2015, that section is blank and I cannot populate it with a data set.

I have updated SSDT and rebooted.

Answer 1

The problem was with the Target Server Version in the Project Properties. The new installation of Visual Studio 2015 had it defaulting to vNext. Switching it to SQL Server 2012 caused the configuration to show up.

Answer 2

I had the same issue and I resolved the problem by selecting Foreach File Enumerator option under collection. By default under Collections >> Foreach Loop Editor >>> Enumerator was set to foreach Item Enumerator as shown below

Default Config for Foreach Loop Container

Instead of "Foreach Item Container" aka the default value, I clicked on it and selected Foreach File Enumerator option and that resolved my problem. Please see snapshot below

Corrected configuration for Foreach Loop Editor