title: Error in script component
body: <p>HI, i am geting following error while laoding the data from table1(stg) to table2(std).In the script component,I am trying to find  string "ABC" in perticular colulmn and replacing that string to "0.00" using c# in script component.</p>
  
  <pre><code>at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.CheckStatusAndNull(Int32 columnIndex)
  at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDecimal(Int32 columnIndex)
  at Input0Buffer.get_Underlying2()
  at ScriptMain.Input0_ProcessInputRow(Input0Buffer Row)
  at UserComponent.Input0_ProcessInput(Input0Buffer Buffer)
  at UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer)
  at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
  </code></pre>
  
  <p>But the error displays here for some other column (Underlying2).Error says the column has null value.
  I have applied the constraints as  cleanbuffer.column_isnull=true;
  still it shows the same error.</p>
  
  <p>please help to solve the above issue.I am new to c# coding.</p>
  
  <p>Thanks.</p>