2

A user is missing the new button (highlighted in the snapshot) that appears for me in the Connection Manager's OLE DB Destination Editor in Visual Studio. The user is a sysadmin on the database.

example button

Thanks for any help!

Hadi
  • 36,233
  • 13
  • 65
  • 124
emreimer
  • 71
  • 1
  • 1
  • 7
  • That doesn't seem like an effective long-term solution. However, you might check what your permission is verse your coworkers. SysAdmin vs ??? – KeithL Feb 27 '20 at 16:48

2 Answers2

0

Trying to figure out the issue

The following steps are some possible solution:

  1. Visual Studio installation should be repaired or need to be updated
  2. Change the package TargetServerVersion property to the relevant SQL Server version.

  3. A third party extension is causing this issue, you can try to run Visual Studio in safe mode using the following command: 

    devenv.exe /safemode
  4. It could be a rendering issue, try changing the screen resolution
Hadi
  • 36,233
  • 13
  • 65
  • 124
0

Are you connected the destination before you edit it? If no try to connect it first then edit, it works for me

ibrahim elfakharany
  • 1
  • 1
  • This does not provide an answer to the question. Once you have sufficient [reputation](https://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](https://stackoverflow.com/help/privileges/comment); instead, [provide answers that don't require clarification from the asker](https://meta.stackexchange.com/questions/214173/why-do-i-need-50-reputation-to-comment-what-can-i-do-instead). – Tyler2P Dec 05 '20 at 10:20