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

under the connection managers ,for the flat file connection manager.double click it and for the text qualifier tab keep " . this should sort out your problem

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