Search code examples
sql-serverssisetlsmo

SSIS FOR EACH SMO


When I open a FOREACH LOOP CONTAINER and choose Foreach SMO enumerator I get the wrong screen. What can i tell my DBA to fix this?

enter image description here


Solution

  • This problem may be caused by the Target Server Version in the Project Properties. The new installation of Visual Studio had it defaulting to vNext. Switching it to Installed SQL Server version may fix this problem.

    You can follow this similar problem it may helps you: