Blob Field is empty

When loading data from ODBC, Access, or SQL Server sources, you may encounter blank blob fields. This issue can be resolved by rewriting your SQL query to ensure all blob fields are placed at the end of the query. This simple adjustment helps prevent blank blob fields and ensures proper data retrieval.

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

Confused? Ask question on our ETL Forum

Posted on November 14, 2025 • 1 min read • 123 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License