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


select field1,blob1,field2 from table


select field1,field2, blob1 from table

Also Read:

Invalid Descriptor Index

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

Confused? Ask question on our ETL Forum
Last updated: April 13, 2022