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

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

Answer 2

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 3

You have a problem is your visual studio. (below a screenshot of ADo enumerator from my computer , using visual studio 2015)

• Try running visual studio in safe mode so if this was caused by an add-on it will be fixed. just run this command

  devenv.exe /safemode
  

• If not working Try repairing your SQL Server Data Tools installation or Download the Latest release