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.
Thanks for any help!
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.
Thanks for any help!
The following steps are some possible solution:
TargetServerVersion
property to the relevant SQL Server version. 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
Are you connected the destination before you edit it? If no try to connect it first then edit, it works for me