SSIS dialog box suffers from sizing issues

Michiel Matthijssen 0 Reputation points
2023-02-21T10:33:05.57+00:00
  • When opening the editor for a SQL Server Integration Services (SSIS 15.0.2000.180) lookup transformation component in Visual Studio 2019 (16.11.24), the dialog opens with a width of 714 pixels, and looks weird and maimed: The width of the "Cache mode" and "Connection type" panels is smaller than usual, causing "OLE DB connection manager" not to display fully; the width for the combobox below "Specify how to handle rows with no matching entries" is apparently too small, because it does not show at all.

Luckily I can increase the width of the whole dialog to 1029 pixels, causing all text and boxes to become visible, with a lot of empty grayness in the right side of the box, a waste of some 380 pixels.

The tool seems to be confusion dimensions because one of my monitors is 4K (3840x2160) scaled 150% (to keep things readable). But the problem manifests itself also on my other monitor (2560x1440), and remains when I set scaling to 200%. It disappears when I set scaling to 100% (making everything very difficult to read).

How can I solve this issue?

User's image

Width 1029:User's image

With scaling disabled:

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
Developer technologies | Visual Studio | Other
{count} votes

1 answer

Sort by: Most helpful
  1. Michiel Matthijssen 0 Reputation points
    2023-02-23T09:42:07.56+00:00

    I stumbled upon a fix:

    • VS was running on a machine that I connected to via a remote desktop session.
    • Leaving VS open on the 4K monitor unscaled, I closed the remote desktop session.
    • I reset the monitor to 150% scaling and reopened a remote desktop session to the machine running VS.
    • After allowing VS to adjust to the new monitor dimensions and reopening the lookup editor, the dialog box was normal again, like the 3rd screenshot above.

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.