i wrote sql server table data to .csv file by using SSIS package. In flat file conncetion i've mentioned semi-colon as delimiter. Some of the values in my table are having commas(for example : CODE A,B,C) in .csv file CODE A is coming into 1st column and B is in 2nd vice-versa. now how can i keep all these values in a first column of .csv file with delimiter as ;
1
votes
I seem to be missing the point, if you're delimiter is a semi-colon, commas will have no effect on it and the those values should be in the first column. Perhaps you could show the data to better explain your problem? Also, how are viewing the data to know that it is not delimited correctly?
- Mark Wojciechowicz
value in table is : Security, Audit. In .csv it's coming as In colum1 : Security In cloumn2 : Audit
- P.S. Rao
No it's not. Not if the .csv is delimited by semi-colons. You are merely misinterpreting what you are seeing.
- Tab Alleman
It should something like this "Security, Audit;Column2;Column3;..."
- Mark Wojciechowicz
I'm using the Format : Delimited,Header row delimiter is ; and Row delimiter {CR}{LF},Column Delimiter is ; value Security, Audit. In between comma and audit we have one space.
- P.S. Rao
