title: Need to add substring() column after destination oledb table
body: <p>I simple created a SSIS dataflow and I got the OLEDB Destination table but I want to add one more column on my final table but it seems like I am not able to do it. any suggestion. </p>
  
  <pre><code>SELECT [NAME]
  ,[ID]
  ,[TYPE]
  ,[CLASS]
  ,[START_DATE]
  ,[END_DATE]
  ,[LINE1]
  ,substring([LINE1],1,5) c
  ,[LINE2]
  ,[LINE3]
  ,[LINE4]
  ,[CITY]
  ,[STATE]
  ,[POSTAL_ZIP]
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/mLUbF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mLUbF.jpg" alt="enter image description here"></a></p>