~|~ Delimiter. Has anyone seen ~|~ as a delimiter?

Question

I received the text files from our vendor every morning. The file contains ~|~ as a delimiter.

Has anyone ever seen this kind of delimiter and if so, how do you handle this kind of delimiter?

I am using SSIS Package to import the text file into SQL Server 2019.

Thank you in advance for your help.

Answer 1

Hi @Villa,

You may set the custom delimiter in flat file connection manager editor like shown below.

Regards，

Zoe Hui

---

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

Answer 2

Odd delimiter but shouldn't be an issue. Nothing says a delimiter has to be a single character. In general you just need to set your delimiter to whatever string is being used. But you didn't provide us information about what task you're using for this so it is hard to tell you how to proceed.