Foreach ADO Enumerator does not show ADO source variable

Question

I like 1 hour of SSIS experience, so I don’t know why this is happening.

I follow this guide .

However, when I get to the section of the screen of the Foreach loop editor and select "ADO ADA Enumerator", I do not see the section of the ADO Object source variable.

The screen should look like this:

Any ideas?

I am using Visual Studio 2015 and a candidate for SSDT, so this can be a problem.

I correctly completed all the steps and did not see the errors of the previous steps.

Answer 1

I was looking for this problem and I found two simple sentences:

• ( )

  devenv.exe /safemode
  

• SQL Server

Answer 2

; :

SQL 2014:

→

→ → → .

Answer 3

SSIS ADO .

SSDT [Release 17.0] [Build 14.0] Project Level TargetServerVerion SQL Server vNext. .

Changing this for any other value was a fix for me.

Solution Explorer Window -> Right-click Project -> Properties -> Configuration Properties -> General -> TargetServerVersion = SQL Server 2016