title: Automated export of SQL Server data
body: <p>I want to export large amounts of data, out of a SQL Server 2008 Enterprise, to a flat file. Then delete that data.  Naturally the delete must only happen if the export succeeds, so this must be synchronous.</p>
  
  <p>Ideally this would be parametrized for date ranges. The filename also needs to change to reflect the exported data (i.e. exported_data_20110401_20110501.tsv, or similar)</p>
  
  <p>I want this to be automated so that it can happen periodically. </p>
  
  <p>What's the best workflow/tools to make this happen these days? The SSIS functionality seems a bit deprecated in SQL Server 2008?</p>
  
  <p>Thanks.</p>