How to do mapping in OLEDB Command Transformation when column have special characters to SQL SERVER while doing SSIS Package?

Question

I have problem in developing SSIS package on Column Mapping in OLEDB Command:

Below are the two columns in my table:

Trans_Vendor#

Trans_Receipt#

I can able to read the data using Backticks from begin and end of the column from DataLake source..

But I got an issue while trying to map in OLEDB Command in SSIS. I tried below three ways but unsuccesful...

'Trans_Vendor#'

"Trans_Vendor#"

[Trans_Vendor#]

Answer 1

Hi @Ramana Kopparapu，

What's the error message said?

I test locally that there is no issue if my column contains special characters.

Could you please show us the settings of your OLEDB Command?

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.