Blob Field is empty

When loading data from ODBC/ACCESS/SQL Server source it is possible to have all blob fields blank.

The problem can be easily addressed by rewriting SQL and making all blob fields last in the query

Change

select field1,blob1,field2 from table

to

select field1,field2, blob1 from table

Also Read:

Invalid Descriptor Index