avoid columns data "" in ssis package

• asranantha

  SSCarpal Tunnel

  Points: 4246

  More actions

  February 21, 2013 at 1:15 am

  #270652

  hi 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 , jai

  plese tell me how to solve this issuse

• sumit.joshij

  Ten Centuries

  Points: 1040

  More actions

  February 21, 2013 at 1:32 am

  #1589828

  Use "text qualifier" in File Connection Manager as " (doubleQuotes).

  🙂

• sumit.joshij

  Ten Centuries

  Points: 1040

  More actions

  February 21, 2013 at 1:43 am

  #1589830

  Or in more complex scenario using the Derived column, you can use the given below expression:

  REPLACE([Column 1],"\"","")

  Thanks and Regards,

  Sumit Joshi

  Moblie:- 0-9650899699, Skype: sumit.joshij

  Blog: http://msbi2012.blogspot.in/