title: SSIS package performance enhancement
body: <p>I have a log table that I am planning to import from my Transaction Database to my reporting Database.</p>
  
  <p>The columns of the table are as follows:</p>
  
  <pre><code>Id,Varchar1 , Varchar2, Time1, Time2 
  </code></pre>
  
  <p>XML structures are stored in Varchar1 &amp; varchar2</p>
  
  <p>I am using a SSIS package and a data flow task with an OLEDB source and destination.</p>
  
  <p>There are close to 600000 records in the table and its taking an extremely long time to transfer.</p>
  
  <p>The queries that I tried so far in my OLEDB source are :</p>
  
  <p>1)<code>select Id, XML1, XML2, Time1, Time2 where Time &gt; 'XXXX' and Time2 &lt; 'XXXX'</code></p>
  
  <p>Converting Varchar to xml 
  2) </p>
  
  <pre><code>select Id, CONVERT(XML,CONVERT(NVARCHAR(max),Varchar1, 0)), CONVERT(XML,CONVERT(NVARCHAR(max),Varchar2, 0))
  , Time1, Time2 where Time &gt; 'XXXX' and Time2 &lt; 'XXXX'
  </code></pre>
  
  <p>Both the queries take me an extremely long time.</p>
  
  <p>Does anyone have a better solution/approach to achieve my task ? </p>