I am loading pipe (vertical bar) delimeted text files into SQL Server tables.
The actual data shouldn't have | character , however, it happens from time to time. And the file cannot be loaded unless we manually correct the data.
I would appreciate any ideas on how to improve loading process.
Thank you in advance.