InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 17:39:35 GMT20http://www.sqlservercentral.com/Forums/Topic1422423-147-1.aspxOr in more complex scenario using the Derived column, you can use the given below expression:REPLACE([Column 1],"\"","")Thanks and Regards,Sumit JoshiMoblie:- 0-9650899699, Skype: sumit.joshijBlog: http://msbi2012.blogspot.in/Thu, 21 Feb 2013 01:43:00 GMTsumit.joshijhttp://www.sqlservercentral.com/Forums/Topic1422423-147-1.aspxUse "text qualifier" in File Connection Manager as " (doubleQuotes). :-)Thu, 21 Feb 2013 01:32:47 GMTsumit.joshijhttp://www.sqlservercentral.com/Forums/Topic1422423-147-1.aspxhi friends i have small doubt in ssis package source data come text file that file contain data like id , name 1 , "ravi" 10 , "venky" 1000 , "dd" 14200 , "jai"when ever weload this data into destnation that time data must be load like this way id , name 1 , ravi 10 , venky 1000 , dd 14200 , jaiplese tell me how to solve this issuseThu, 21 Feb 2013 01:15:28 GMTasranantha