In a particular column the data entered in the database ( through UI using a multiline textbox) the unicode for enter key also gets saved. while retrieving the data using a ssis package the data gets split into different lines whereever the enter key is there.so how to remove the unicode for enter key or how to retrieve the data in a single line??

Please post a example what type of data you are getting from table and what you want in output... Thanks Sumit

Hi When you are selecting the column , replace the CHAR(10)+CHAR(13) charecters from the column while you are selecting or place (\n) charecter from the column with blank value. Regards Naveen

I guess you want to export the data to a flat file / csv and you see the enters in that file? http://bturnip.com/nerdalerts/archives/25 or replace "\n" by ""Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

I guess you want to export the data to a flat file / csv and you see the enters in that file? http://bturnip.com/nerdalerts/archives/25 or replace "\n" by ""Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

thanks!! but i used the REPLACE(column_name,' ','') to remove the unicode for enter key in the data...its working!!!