title: Which is faster for SSIS, a View on a table or a Conditional Split?
body: <p>I have an SSIS project where one of the steps involves populating a SQL Server table from an Oracle Table. </p>
  
  <p>The Oracle table has a column <strong>ssis_control_flag</strong>. I want to pull across all records that have this field set to 'T'. </p>
  
  <p>Now, I was wondering which would be the best way of doing this, and the two options as I have detailed in the question presented themselves.</p>
  
  <p>So really, I am wondering which would be faster/better. Should I create a conditional split in the SSIS package that filters off all the records I want? Or should I create a view in Oracle that selects the records based on the criteria, and utilise that view as the data source in SSIS?</p>
  
  <p>Or is there an even better way of doing this? You help would be much appreciated!</p>
  
  <p>Thanks</p>