Symptoms:

Previewing or using SSIS transfer on a table that contains Geography or Geometry data types results in an error.

Error Message:

When previewing:

1 row could not be displayed!

When executing:

DataReader.GetFieldType(<Number>) returned NULL

Underlying Problem:

TimeXtender 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.

Solution:

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.