title: How to remove control characters from DTS/SSIS imports?
body: <p>The company I work for has a lot of systems where the source data originates as a flat file or Excel workbook. These files are then imported using DTS into a SQL Server database.</p>
  
  <p>Quite often these files contain various control characters (for instance I've just spent an hour finding that some records have a <code>\0</code> in them which apparently SAP like to pad things with) which ideally we would like to strip out before they get into our database.</p>
  
  <p>I've not used DTS/SSIS that heavily, but I thought that there must be something already in them, or at least a sanitisation best practice, that I should be using?</p>
  
  <p>Any ideas on how to do this in a repeatable fashion across many imports would be appreciated.</p>