Share via

Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications

Norman K. F. Chow 75 Reputation points
2024-03-09T15:50:00.2433333+00:00

I have been following the SSIS tutorials from Microsoft Learn:

https://learn.microsoft.com/en-us/sql/integration-services/lesson-6-4-deploying-the-lesson-6-package?view=sql-server-ver16

I am currently stuck at step 8 of "Add the package to the SSISDB catalog":

User's image

Any idea to help me get around of this error is much appreciated.

Norman

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,551 Reputation points
    2024-03-11T05:29:32.8633333+00:00

    Hi @Norman K. F. Chow,

    Have you installed the SSIS service?

    Check Install Integration Services (SSIS).

    In the SQL Server Setup Wizard, select New SQL stand-alone installation or add features to an existing installation. To install Integration Services, make selections on the Feature Selection page.

    User's image

    Regards，

    Zoe Hui

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