title: Replacing " " with comma (,) in SSIS
body: <p>I am trying to import a text file in which tab delimited and text qualifier is double quotes.
  I am following guide:
  <a href="http://www.ideaexcursion.com/2008/11/12/handling-embedded-text-qualifiers/" rel="nofollow">http://www.ideaexcursion.com/2008/11/12/handling-embedded-text-qualifiers/</a></p>
  
  <p>I want following text </p>
  
  <pre><code>"655295" "Keisuke" "" "Ueda" "1-2-2, Central Park East F201" "Utase, Mihama-Ku"
  </code></pre>
  
  <p>to convert to</p>
  
  <pre><code>"655295","Keisuke","","Ueda","1-2-2, Central Park East F201","Utase, Mihama-Ku"
  </code></pre>
  
  <p>I tried derived column transformation, but it did not help. I tried script component, but that didn't work either. Can someone please help me out here.</p>
  
  <p>Thank you in advance!!</p>