How does SSIS store and access a SQL result set ?


  • My code stores a huge result set. It processes this result set and then loads it to the target. Lets not discuss about the efficiency of this technique now.

    I need to know if the result set is stored fully or partly in RAM. If it is full, then I might have problems when the result set is very big. Otherwise, I don't think there will be a problem. 

    Also, does a result set remain in memory even after it is filled into a datatable ? If yes, then I will also have to deallocate this memory. 
    Friday, November 08, 2013 12:52 AM


All replies