I have created a data source that works correctly when an Excel file is attached. I can see that the fields in the staging table are being populated correctly. However, when I try to run a data transformation (transform map) and log the "source" object at the beginning of the script, it appears to be empty:
Please help me understand why the "source" object is empty, even though the staging table is being populated correctly. Can anyone explain why this is happening or provide suggestions on how to resolve it? I would greatly appreciate any guidance and advice.
