I had some legacy ETL package which was developed in 2012. After Installing Visual Studio 2017, I opened the package in VS2017 and had no issues in opening the package. I checked all the components in the package and it worked fine EXCEPT for "ADO.NET Destination" component
It does not open the Editor Window no matter what I did. I installed all the .NET Framework versions thinking it may be the issue. But still it didn't work. After checking online, someone suggested to install Entity Framework which I also did, but still didn't solve the problem.
I can open the same package without any issues in Data Tools 2015 and 2012.
Has anyone seen this issue before and how was it solved?