If you have a legacy PostGreSQL Database Source (ODBC) that you want to consume via SSIS (SQL Server Integration Service) you will get the Warning “‘Row by Row’ fetch method is enforced because the table has LOB column(s). Column content is LOB” if a Column is defined as text. The ODBC treats long text (longer as 128) as LOB datatype (NTEXT). A lob is a large object that can store very long texts (CLOB) or binary files (BLOB).
Example of tables with LOB
CREATE TABLE annotation.document ( largeText text )
Solution 1: Cast in the Data Souce:
Use Cast(“TextColumns” as varchar(100)) in your Query instead of accessing only the ColumnName.