DataReader.GetFieldType(24) returned null

[tresf]

When running the project against SQL Server 2017 instance:

Exception calling "Fill" with "1" argument(s): "DataReader.GetFieldType(24) returned null."
At GetMsSqlDump.ps1:287 char:5
+     $adapter.Fill($ds) | Out-Null
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : InvalidOperationException

Similar article here and the proposed fix is to add C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Types.dll to the assembly, but I'm not sure how to do this with PowerShell.

[tresf]

On my machine, this was fixed by installing the SQLSysClrTypes.msi package from SQL Server 2016 and restarting powershell.