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”

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.