Clever Geek Handbook

Missing enumerator in loop editor

I am on a new laptop running Visual Studio 2015 with SQL Server Integration Services package.

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

enter image description here

In VS 2015 this section is empty and I cannot fill it with dataset.

enter image description here

I updated SSDT and rebooted.

+4


source to share


3 answers


The problem is with the version of the target server in the project properties. A fresh installation of Visual Studio 2015 had the default for vNext. Switching to SQL Server 2012 brought up the configuration.

enter image description here



enter image description here

+6


source


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

enter image description here



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

    devenv.exe /safemode

  • If not working Try repairing the installation of SQL Server Data Tools or download the latest version

+1


source


I had the same problem and solved it by selecting the Foreach File Enumerator option in the collection section. By default under Collections >> Foreach Loop Editor >>> Enumerator has been set for every enumeration element as shown below

Default configuration for container for loop per item

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

Fixed configuration for loop editor for each element

0


source






More articles:


All Articles