Previewing or using SSIS transfer on a table that contains Geography or Geometry data types results in an error.
1 row could not be displayed!
DataReader.GetFieldType(<Number>) returned NULL
TX DWA uses the SqlDataReader class from the .NET framework, which in turn relies on the Microsoft.SqlServer.Types.dll The latest available version of this .dll (10.0.0.0) is from SQL Server 2008, and may no longer come pre-bundled in the newer versions of SQL Server.
The necessary .dll file is included in the in the feature pack for Sql Server 2008 R2, and can be found here.
Please follow the link, click on the Install Instructions and scroll down to Microsoft® System CLR Types for SQL Server® 2008 R2.
Note that there are three versions of the DLL:
- X86 Package(SQLSysClrTypes.msi)
- X64 Package (SQLSysClrTypes.msi)
- IA64 Package(SQLSysClrTypes.msi)
Please pick the package appropriate for your server architecture.