title: Duplicated derived column logic
body: <p>I need to import a series of CSV files. They have about 30 columns, most of which are supposed to be numeric. The process that generates them uses "NA" to indicate NULL values and "Inf" for infinite (divide by zero issues), which should be converted to 99999.</p>
  
  <p>I created a derived column transform for the first column, which was simple enough, but now the only way that I can think of to use it for the other columns is to copy/paste then alter the code 30 times. Then I would need to remap everything of course.</p>
  
  <p>Is there a simpler way? Some way to just say, "Apply this logic to all of these columns". I'm at the point where I just want to import the data into a table of all NVARCHAR() columns and do the work in T-SQL, but it seems like SSIS should be able to handle this more elegantly.</p>
  
  <p>Thanks!</p>