I'm starting to learn about SSIS, I already know how to import a Flat File into the Bank, however I have a problem, the delimiter used is the Pipe "|", and in one of the columns it is used as value.
When importing an extra column is "generated" because of this and all data is shifted to the right
I can not ask to generate a new file or change the delimiter
How can I solve this problem using SSIS?
What is the best way to start?