You can read data from tables containing unsupported data types by using two possible workarounds - first, by creating a view or, secondly, by using a stored procedure.
To use the first workaround, create a view in the SQL Server database that excludes the unsupported column so that only supported data types are available. For more information on views, see
MSSQL Server data source views.
To use the second workaround, write your own stored procedure with the
RUN STORED PROCEDURE statement or write SQL into a
SEND-SQL-STATEMENT stored procedure call that expresses Data Manipulation Language (DML) adequate to handle the table object without the unsupported types. You can omit the unsupported data type in your DML statements such that they are not returned in the result set or are
CAST to data types that are supported. For more information on stored procedures, see
RDBMSStored Procedure Details.
