SSIS SSMS comma issues on CSV

0
votes

I'm having some issues dealing with commas on a export from a datatable to a CSV flat file using SSIS and SSMS. Some values on the table have commas 'e.g. Enterprise, S.A.' and the export wizard separated that value on another column, 'Enterprise' and 'S.A.'is there any solution to ignore that comma or change the type of delimiter to keep the data together?

1
visual-studiocsvssisssms
Quote wrapping text works for me - KeithL
Probably a duplicate stackoverflow.com/q/23289514/1531971 (If not, tell us why not as an edit.) - user1531971

1 Answers

1
votes

You can use SSIS to send the data to a flat file destination and use a delimiter other than a comma to distinguish columns. When creating a Flat File Connection Manager, choose the Delimited format and in the Advanced pane change the ColumnDelimiter property for each column from a comma to another delimiter. The Fixed Width and Ragged Right formats are options as well.