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 tableto
select field1,field2, blob1 from tableAlso Read:
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum