Hi All, In my SSIS package one of the column is having value like "abx,co" while exporting this value to CSV file "co" is coming in the next column in stead of coming in the same column. Pls suggest me a work around to ignore the comma inside the string so that it'll load into the same column. Thanks

Or if you have access to the source system, change the delimiter in the CSV to a decent one, such as pipe | or even better, a combination of symbols. My personal favorite: |$MCTS, MCITP - Please mark posts as answered where appropriate.

Hi Nishink, Thanks for ur early response. The value is abx,co in order for others to understand i put iniside "". Secondly when i am changing the text qualifier from <none> to "" . "" gets concatinated with all the values including the column headers. So no luck here. Thanks

Secondly when i am changing the text qualifier from <none> to "" . "" gets concatinated with all the values including the column headers. Is that a problem?MCTS, MCITP - Please mark posts as answered where appropriate.

Sorry Koen I am not supposed to change the source system it has to be csv. Thanks

can u give some sample how your source data is?. As if no text qualifier is being specified then u will be facing problem . As the column delimiter by default is comma (,) so it is obvious that your sentences will get split up and you wont be getting the the data in the desired way.so you should ask your people who are providing you the source data file to use proper text qualifier if your source data column values have comma in between

How to change the deliimeter in the source sys. Could you pls suggest. Thanks

abc def xyz 1 1,2 23

IF column having more comma's like "abx,co,12,sd"....text qualifier tab option is not working ..can you tell how to resolve I just tested it with a flat file consisting out of 3 columns: 1,"abc,def,ghi",3 Configured " as text qualifier and it works perfectly.MCTS, MCITP - Please mark posts as answered where appropriate.

i am using " in text qualifier tab because in one colunm i have comma and problem solved for comma and new problem coming "a,b,c,d"===now no issue "ab"ccc"--this is single column and now issue is coming and its spliting to 2 to 3 rows

i am using " in text qualifier tab because in one colunm i have comma and problem solved for comma and new problem coming "a,b,c,d"===now no issue "ab"ccc"--this is single column and now issue is coming and its spliting to 2 to 3 rows Your format is totally messed up. You configure a text qualifier, but then the text qualifier pops up in the strings themselves. That's just asking for troubles. Talk to the person responsible for creating those files and tell them a) the format is being misused and b) to choose a decent delimiter and text qualifierMCTS, MCITP - Please mark posts as answered where appropriate.

IF column having more comma's like "abx,co,12,sd"....text qualifier tab option is not working ..can you tell how to resolve

IF column having more comma's like "abx,co,12,sd"....text qualifier tab option is not working ..can you tell how to resolve I just tested it with a flat file consisting out of 3 columns: 1,"abc,def,ghi",3 Configured " as text qualifier and it works perfectly.MCTS, MCITP - Please mark posts as answered where appropriate.

use condition split, replace the , to space.