How to load the data from source when there are two delimiters using SSIS?

Question

Below is my data in source document. The document has two delimiters like tilde(~) and pipe(|)..

~id~|~name~|~gender~|~age~

~101~|~ABC~|~M~|~28~

~102~|~DEF~|~F~|~27~

How can I load the data into SQL table Emp?

Please look into this and do neeedful

Thanks in Advance.

Answer 1

Hi @Ramana Kopparapu,

You may set the custom delimiters when load the file.

And then you may use replace function to remove tilde(~).

Please check below steps.

Regards，

Zoe Hui

---

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

Answer 2

Use only the tilde ~ as column delimiter and ignore every second column in the import data flow.