title: ssis dataflow buffer
body: <p>I know that SQL server use memory cache for the all operations by loading data from hard disk to RAM when ever we select or update or etc.Also,I have read like SSIS also use some buffer for data flow task.So, my questions are..</p>
  
  <p>1)Whether these buffer and cache are same?</p>
  
  <p>2)If yes,We used to write sql statment inside the data flow task(eg:OLEDB Data Source task) so SSIS has to create some buffer for loading data.Whether the executed sql statment inside the OLEDB Source task will not create any cache?</p>