Problem
When running a integration job which has excel file as source, the process is failing with below error message:
Task: Task 1
This Task has failed
DI Error: Failed to apply transformation: Column 'GL Test' does not belong to table., To resolve, provide ID: 046b9bcbbb754797a312e66921c3c6a6 to our support.
Connection to Text source - Success
Data in Text file: xyz.tmp has been transferred to destination
Data gathered from Text source - Failure
Time task started: 5/28/2025 4:34:56 AM UTC
Time task ended: 5/28/2025 4:34:56 AM UTC
Task duration: 0 min O seconds
Records extracted : 18
Records copied : 0
Cause
This issue occurs if there is a trailing space in column header.
Solution
Check the excel file column headers and ensure the heading does not have trailing spaces.
Comments
Article is closed for comments.