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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/blob_field_is_empty.txt
  • Last modified: 13/04/2019 17:24
  • by admin