SSIS Toolbox only shows "loading …" but no items

Rodegru 0 Reputation points
2023-02-03T23:51:32.1433333+00:00

My SSIS project in Visual Studio Community 2019 suddenly stopped working. Error see title.

What I tried so far:

  1. repair VS 2019
  2. uninstalled/ installed SSIS Extension
  3. updated VS 2019 (16.8.6 -> 16.11.23)
  4. updated SSIS (4.4 -> 4.4.2)
  5. created a new SIS Project
  6. right clicking in the toolbox (does nothing)

All without success. Always the same error. What else can I try?

SS01_ISVS

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,172 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,587 questions
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 37,221 Reputation points
    2023-02-06T02:09:19.4566667+00:00

    Hi @Rodegru

    Please refer to the following steps:

    1. Close Visual Studio (make sure devenv.exe is not running).
    2. Open the folder %userprofile%\Local Settings\Application Data\Microsoft\VisualStudio[16.0]
    3. There should be two-four files ending in .tbd (they may be hidden, so you'll have to set your options to show hidden folders and files).  Delete them.
    4. Start VS again.

    If the steps do not work, try to use the SSIS project v3.6.

    If these all do not work, please report the issue here, hope that the product team will help us resolve it.

    Regards,

    Zoe Hui


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

    0 comments No comments

  2. Rodegru 0 Reputation points
    2023-02-06T15:19:39.7533333+00:00

    Hi Zoe Hui

    Thanks for the support.

    (1) Deleting the *.tbd files.

    -- >no success

    (2) Downgrading SIIS to 3.16 (your link pointed to this version and not to 3.6).

    -- > no success

    Thanks

    Robert


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.