ERROR: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse)

syazwan amir 20 Reputation points
2023-02-08T07:25:00.0866667+00:00

Hello,

When I want to edit the configuration file at Package Configuration Wizard, I get this error: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse)

Please refer to the screenshot below.

error

Kindly help and suggest the steps which I need to take in order to solve this problem?

Below are the details for the software and environment that I used:-

  1. Microsoft Visual Studio Community 2019
  2. Windows Server 2019
  3. SQL Server 2016
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,370 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,602 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,706 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,119 questions
Accepted answer
  1. ZoeHui-MSFT 32,736 Reputation points
    2023-02-08T08:22:12.63+00:00

    Hi @Syazwan Amir

    Here is a same issue here you may take a reference to.

    A work-around for now:

    It will allow you to add a brand new .dtsconfig file

    • Right click inside the package and select Package Configurations
    • Click Add
    • Type in “test”
    • Pick any single property in the list and check it (i selected Variables->myVar->Properties->Value)
    • Click next
    • Type “workaround” for the Configuration Name
    • Click Finish
    • Click Close

    Right-click on the dtsx package and view code (or press F7)

    • Search for the word “workaround”
    • change the path in “DTS:ConfigurationString”
    • optionally change the name in “DTS:ObjectName”
    • save

    Regards，

    Zoe Hui

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

    2 people found this answer helpful.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. syazwan amir 20 Reputation points
    2023-02-09T02:06:33.2733333+00:00

    Hi @ZoeHui-MSFT ,

    Thanks for the response and suggestion.

    I managed to fix it as per the suggestion.

    However, I have more than 10 packages that use the same .dtsconfig file.

    Since all of the packages have the same issue, may I know if is there any workaround that can fix this problem?

    0 comments
  2. VARIN Herve 0 Reputation points
    2023-06-21T15:14:52.1333333+00:00

    Hi @ZoeHui-MSFT ,

    I've the same problem with SSIS2022 and SQL server 2019.

    Do you create a fix quickly ?

    Best regards,

    Herve VARIN

    0 comments
  3. Rakesh 0 Reputation points
    2024-02-26T13:57:57.98+00:00

    I am using VS 2019 with SSDT and facing same issue when try to use the configuration file across packages. Has this been resolved? Can't be making changes across dozens of packages.

    0 comments