imported three small-ish csv files. weird formats, took me forever to get it into place. finally got it, and a very small percentage of several columns for a handful of records, have been split out into additional columns, like this:
this is one attribute: AEROTAXI EJECUTIVO, S.A.
it was loaded so that the 'S.A.' is in a column by itself, like this: AEROTAXI EJECUTIVO, S.A.
same thing with this one: ARION SHIPPING CO. LTD.
one column, but it went in as two: ARION SHIPPING CO. LTD.
Unfortunately, it's not all 'S.A.' or 'LTD.'... it varies. Also, it's not always a comma separator. As you can see, in my second example there is no comma.
I either need to persuade SSIS to upload without the column separation, or I need to just update the data, selectively. This is not a recurring upload, so the latter would be fine. I'm just having a problem CASEing the update from the second column.