title: Create SSIS package to import from one of many data sources
body: <p>Is it possible to create an SSIS package that can be passed a file (through a variable) and from the variable determine which Data Flow Task to use?</p>
  
  <p>What I would like to be able to do is to create a single DTSX package that can take in a filename as a variable and detect (simply from the filename) if it is an Excel 2003, Excel 2007 or CSV file and from that, execute the correct Data Flow Task.  I will then process the results in another single Data Flow Task after the data has been imported.</p>
  
  <p>I used SSIS a long time ago and I am just coming back to using it so my knowledge is locked away and will come back slowly.  I just can't seem to remember (or find on Google) a way of creating a conditional split in the Control Flow.</p>
  
  <p>Any ideas?</p>