When using the ODBC connector, the table column name contains special characters such as “$”. At runtime, the flow goes into error.
Here you have to make some changes when using ODBC as a source containing special characters.
Step 1: Go to the Specify Driver Attributes option.
Step 2: Checked Override default driver attributes.
Step 3: Go to the Table Name Treatment Field and select “Doublequote” from the dropdown option.
You are then good to go.