I've checked "Skip validation when opening a package" so when opening a package it doesn't freeze, but when going down to data flow level, it starts validating the connection and freezes. I would chalk it up to it being a big database, but on other machines, it works without a hitch. Do you guys have any advice?
2 Answers
Check your individual connections, you might need to set delay validation to true on the connections too.
I too was having this issue when going into a data flow. I am on VS 2019 16.11 and SSIS 3.16 (not Preview 4.0). I changed the DelayValidation to True on the Data Flow and the project, and it resolved my issue.
Related