title: How to load data from text file into a single column using SSIS
body: <p>I have a text file with huge data and the data are comma separated. I am trying to load the data into a single column and then perform some string functions using derived column to get the data that is needed and save it to a CSV file. The data has lot of noise. Whenever I am  loading the data into a single column and trying to use string operations it shows me an error saying the data is in <strong><code>DT_TEXT</code></strong> format. I am trying to typecast it into <strong><code>DT_String</code></strong> but no luck so far.</p>
  
  <p>I am guessing maybe I am loading the text file in a wrong way. Whenever I am loading it into a single column I am facing this problem. </p>
  
  <p>Any leads would be of much help!</p>
  
  <p>The data in the text file looks like this.</p>
  
  <pre><code>{"ts":"2016-08-01T13:28:14.136","pid":2480,"tid":"2db4","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"rotate-log",
  "v":{"new-path":"E:\\Tableau\\Tableau Server2\\data\\tabsvc\\vizqlserver\\Logs\\dataserver_0_2016_08_01_13_28_14.txt","old-path":"E:\\Tableau\\Tableau Server2\\data\\tabsvc\\vizqlserver\\Logs\\dataserver_0_2016_07_31_13_27_15.txt"}}
  {"ts":"2016-08-01T13:28:14.120","pid":2480,"tid":"24c4","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"msg","v":"ACTION: DataSession::ReportException"}
  {"ts":"2016-08-01T13:28:14.120","pid":2480,"tid":"24c4","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"msg","v":"NotifyOfException::std::exception"}
  {"ts":"2016-08-01T13:28:14.120","pid":2480,"tid":"24c4","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"msg","v":"NotifyOfException caught std::exception."}
  {"ts":"2016-08-01T13:28:14.183","pid":2480,"tid":"24c4","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"msg","v":"ACTION: DataSession::ReportException"}
  </code></pre>
  
  <p>Many Thanks!</p>