title: Workaround to get data for processing purposes without data warehouse
body: <p>In my organization we do not have data warehouse or any kind of intermediate data storage used for data processing.</p>
  
  <p>I need to extract data on daily basis for the last 5 years. 
  So to achieve that I run complex stored procedures that inserting the result into Tables, then I write query to join that data and getting the final output.
  Then I truncate those tables and starting the process again. </p>
  
  <p>Below is graphical representation of the process:</p>
  
  <p><a href="https://i.stack.imgur.com/zePyB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zePyB.png" alt="enter image description here"></a></p>
  
  <p>The amount of data is growing. To run those stored procedures requires more and more resources. </p>
  
  <p>What would be my best solution to this problem?
  I have SSIS tool available. </p>