Hi,

I've done a fully dynamic scripts which take the database, the table and sometimes the partitioning column. They were a mix of TSQL and Powershell steps.

The process includes creating a new partition for the new data, switching the old one into the stage table, bcp the stage table into a text file, dropping the staging table and finally dropping the empty files/file groups.