title: SSIS C# Script Task to Clean SQL Records
body: <p>I am trying to piece together a C# script in SSIS to do the steps below:</p>
  
  <ol>
  <li>Establish a SQL Server connection</li>
  <li>Either read the entire contents of a SQL Server table into a <code>DataTable</code>, or process on a row by row basis and export to a new table (not sure which method to use....)</li>
  <li>Search through each column in a row, and if that row has a length of 1 and has a value of '-', replace the dash with NULL.  They key here is that I do not want to declare each of the column names.</li>
  <li>Then write the records back out to another SQL Server table.</li>
  </ol>
  
  <p>I am new to C# so I am looking for the most simple way to do this.</p>
  
  <p>Thanks!</p>