<< BI User Group meeting 2014-11-18, PASS Highlights, SSRS Admin using Powershell | Home | SSMS 17.1 missing features >>

SSIS project foreach loop editor does not show configuration for ADO or ADO.NET enumerator

UPDATE on 2017-05-31:

It seems to be a bug with version 17.1 (build 14.0.61705.170).  I uninstalled that version (including some prerequisite and other components from program list), did a repair on Visual Studio 2015, then installed build 14.0.61021.0.  I was able to see the ADO components working again (but lost the ability to deploy to SQL 2017, as expected).   I will report this to the SSDT team.




ORIGINAL POST:

I set up Visual Studio 2017, but the SSDT for SQL 2016 did not integrate so I am in Visual Studio 2015 Shell.  I just created a Foreach Loop Container, and tried to get to the configuration screen and only see blanks (see below, both ADO ones do not work, but the file one works).  Anybody else see the same issue?



Print | posted on Friday, May 26, 2017 2:39 PM

Feedback

# re: SSIS project foreach loop editor does not show configuration for ADO or ADO.NET enumerator

Left by AJ at 6/7/2017 5:55 PM
Gravatar I am facing the same issue... even I never installed VS 2017. I installed 2015 and connecting to SQL Server 2016.

Please share if you found a solution for this.

Thanks.
AJ

# re: SSIS project foreach loop editor does not show configuration for ADO or ADO.NET enumerator

Left by Life Long Techie at 6/8/2017 8:31 AM
Gravatar AJ,

The post was updated on 5/31 with some steps on how to revert back a version. The build number that worked for me was 14.0.61021.0.

As of 6/8, this link still works: https://msdn.microsoft.com/en-us/mt186501.aspx

Hope this works for you, too.

# re: SSIS project foreach loop editor does not show configuration for ADO or ADO.NET enumerator

Left by UT at 10/26/2017 10:58 AM
Gravatar I faced this issue too and wondered why it doesn't work!
Thank you for your post that notifies it's a bug!!
I did what you did and that fixed.
Just now I can't open my previous solutions
Thanks again

Your comment:





 

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski