SSIS - when I open a solution, change the file name to load, the package freezes

Question

1. Open Visual Studio SSIS
2. Select project
3. Click on Solution (mapping)
4. When I do anything after that, I get a message "Visual Studio is busy. We'll automatically report ... " a) Change Excel Source b) Click on Data Flow c) Click on any other menu entry This project was running w/o issue for over a year.

Answer 1

@Steve Thiboutot,

Please edit your question, and add the following:

• Visual Studio version and its build.
• "SQL Server Integration Services Projects" extension for Visual Studio and its version.

I would suggest to update both:

• VS2019 up to v.16.11.33
• "SQL Server Integration Services Projects" extension for VS2019 up to v.4.5

Answer 2

Hi @Steve Thiboutot,

Do you mean when you open another SSIS solution, the error occurred?

Visual Studio is busy. We'll automatically report

If yes, you may try to repair Visual Studio via Visual Studio Installer.

If this does not work, you may raise the issue to VS side.

Visual Studio Developer Community

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

After I open the Solution (mapping), The only thing it won't freeze on is when I test the dB connection. If I change the source file, hit the Run key, anything, I get exactly that message above. "Visual Studio is busy. We'll automatically report ... " I have 3 projects in which this happens and one that it doesn't happen and I will try and get the administrator to run the repair process and see if that cleans up the problem