title: SQL Server - How to shrink the allocated space for a staging table used by SSIS?
body: <p>I'm facing a strange problem about a staging database used by my ETL (to update rows).</p>
  
  <p>Only rows to update are stored in the database, then a script is executed to update the destination database. At the end of the process, It truncates the staging database.
  It removes all data, however the allocated size for my database grows every execution time of my SSIS package. So, is there a way to reduce the allocated size and to limit the maximum allocated size ? In SQL Server Management Studio, there is a wizard to reduce data size and database size.</p>
  
  <p>Is there the same command in T-SQL ?</p>
  
  <p>Thanks !</p>