ODBC as source having special character in column name

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.