title: SSIS Flat File destination add trailing spaces to columns
body: <p>I am fairly new to SSIS development. I am developing a SSIS package which executes a stored procedure and then outputs the result to a flat file.</p>
  
  <p>I have a requirement wherein I need to have columns of fixed size, so if the length a value for a particular column is lesser than the expected length I need to pad or fill it with spaces so that the length is matched.</p>
  
  <p>From what I researched it seems like introducing a custom script component as transformation can do this for me.</p>
  
  <p>It would be great if someone can suggest if that is the only way to achieve this or are there any better alternatives that I am just missing here.</p>
  
  <p>Any help is greatly appreciated.</p>