title: SSIS 2008 Script Transformation Inputs and Outputs
body: <p>I have a flat file that I need to parse in SSIS, part of this parsing is to chop off a load of extra text at the bottom of the file.  To help do this I added a row number to each row using a Script Transformation.</p>
  
  <p>In the Script Transformation (ST) under Inputs and Outputs I have an Input Column defined called Column256_in (it has a length of 256)  and its ID is 59.</p>
  
  <p>For Output columns I have defined Column256_out, it has an ID of 68 and a MappedColumnID of 59, there is another Output Col called rowCount.</p>
  
  <p>There is script code contained in the ST the calculates the row number for each row.</p>
  
  <p>When I run the SSIS package I have a Data Grid after the Script Transformation I get the following:</p>
  
  <p>Column256_in contains the data from the orginal text file.</p>
  
  <p>rowCount is populated correctly. ( I did something right today!)</p>
  
  <p>Column256_out is empty -->  I thought that the MappedColumnId of 59 would populate   this col with the data from Column256_in.</p>
  
  <p>What does the MappedColumnID attribute do on the Out put col?</p>
  
  <p>Thanks for your assistance.</p>
  
  <p>KD</p>