title: How to Partition a Table by Month ("Both" YEAR & MONTH) and create monthly partitions automatically?
body: <p>I'm trying to Partition a Table by both <strong>Year</strong> and <strong>Month</strong>. The Column through which I'll partition is a datetime type column with an ISO Format ('20150110', 20150202', etc). </p>
  
  <p>For example, I have sales data for 2010, 2011, 2012. I'd Like the data to be partitioned by year and each year be partitioned by month as well. (2010/01, 2010/02, ... 2010/12, 2011/01, ... 2015/01...)</p>
  
  <p>E.X:</p>
  
  <p>Sales2010Jan, Sales2010Feb, Sales2011Jan, Sales2011Feb, Sales2012Dec, etc.</p>
  
  <p>My Question is: is it even possible? If it is, how an I automate the process using SSIS?</p>