Using SSIS to fix extra column error

0

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?

    
asked by anonymous 06.07.2017 / 21:26

1 answer

-1

Try to put a double-quote delimiter in the fields of type string, so it will make the difference when it's text and when it's a delimiter.

    
18.07.2017 / 21:23