SSIS and Visual Studio 2019 – Issues and fixes

I recently wanted to try out Visual Studio 2019 with the SSIS Package designer (and to also try out the KingswaySoft extensions for dealing with Dynamics 365 data integration/migrations. Getting it all to work turned out to be a little bit of a challenge, so here I am documenting the issues I encountered, and what I did to fix it.

Continue reading “SSIS and Visual Studio 2019 – Issues and fixes”

CRM Utilities for Visual Studio – Update to menus, and class generation options

Today I have released an update to the CRM Utilities for Visual Studio 2017 extension.

New features:

Reorganised the menu structure so that the Generate Class options are now grouped together.

Generate Class options menu to allow a custom namespace and class name to be used when generating the class files to represent the Dynamics Entities.

Redesigned the Connection dialog to make it look better, and to include a hyperlink to the instruction pages on this blog.

 

Download
Please note this feature is only available in the Visual Studio 2017 version. This version may still install on VS2015, although I have not personally tested it.

My utilities are now on the Visual Studio Marketplace

Just a quick update to say that all of my Visual Studio extensions are now on the Microsoft Visual Studio Marketplace, and are available to download and install direct from Visual Studio.

Visual Studio Marketplace

Simply go into the Tools menu and choose Extensions and Updates, select Online and search for me, James Hall.  My extensions are the top two in the list.

In theory, if you install them this way, you should get notified of when I update them.

Enabling OneDrive when some pesky admin has disabled it

On my corporate machine, it turns out that the powers that be decided to disable OneDrive.  I have a personal 1TB OneDrive account which I use for all manor of things, and I was not happy about this, so I set upon trying to find out a solution.

I found two useful things.

  • Local Group Policy Editor

    In the Local Group Policy Editor (Control Panel, Local Group Policy Editor, or just search for group in the Cortana Search Box), look for :

    Computer Configuration\Administrative Templates\Windows Components\OneDrive

    Find the key :

    Prevent the usage of OneDrive for File Storage

    And disable it.  If it is not configured, still disable it.

  • Windows Registry

    In the Registry Editor, look for :

    HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\OneDrive

    Find the keys (one, or both, depending on what appears) :

    DisableFileSyncNGSC
    DisableFileSync

    Change those values to 0.

 

Doing both of these may be enough to allow OneDrive to run again.  However, you may find that upon next boot, or if you connect to your corporate VPN, one or the other may have reverted back.

To try and fix this, within the Registry Editor, I have modified the Permissions on the Key Container (the folder : HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\OneDrive) and denied access to if for some of the users and groups.  I think it has worked, but time will tell I suppose.