Visual Studio 2019 completely freezes when going down to data flow level

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?

3

Best Answer

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.

enter image description here

enter image description here

Check your individual connections, you might need to set delay validation to true on the connections too.

Update Connections

I Updated My Visual Studio 2019 to latest version and Problem Solved!

Random Posts

Word, Doubleword, QuadwordPrint number as reduced fraction in Rspark: How does salting work in dealing with skewed dataCMD.EXE was started with the above path as the current directory. UNC paths are not supported. Defaulting to Windows Directory [duplicate]Changing the font size of a specific piece of text - Python/PygameArray push and referencesHow to solve "Missing Marketing Icon. iOS Apps must include a 1024x1024px"How to pass LocalDate as an argument? [closed]Dynamically create section for list in SwiftUIHow to grant admin consent to an Azure AAD app in Powershell?Kubernetes can't start due to too many open files in systemUncaught syntaxerror: unexpected identifier? [closed]What does narrow_cast do?failed to execute 'put' on 'idbobjectstore' evaluating the object store's key path did not yield a valueRobocopy Error 3 "System cannot find the file specified" for 1 file in the folderShow all windows OS X keyboard shortcut for mavericksPowershell folder size of folders without listing SubdirectoriesConvert SQL dump to JSON?Not allowed to "Create Facebook Page" for appWhat is the difference between Amazon S3 and Amazon EC2 instance? [closed]