Share via

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
SQL Server Integration Services
Developer technologies | .NET | .NET Runtime
Developer technologies | .NET | Other
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Answer accepted by question author

ZoeHui-MSFT 41,551 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.

Was this answer helpful?

2 people found this answer helpful.

3 additional answers

Sort by: Most helpful
  1. 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.

    Was this answer helpful?

    0 comments No 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

    Was this answer helpful?

    0 comments No comments

  3. 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?

    Was this answer helpful?

    0 comments No comments

Your answer

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