Stuart Ozer developed a simple, shared source Partition Management Tool for SQL Server 2005 to make the process of creating the staging tables for partition management nearly foolproof. At runtime, the definition of all columns, indexes, and constraints for the partition table are read using the SMO object model, and a perfect clone table matching a specific partition is created.

The Partition Management Tool runs from the command line. The tool can be invoked from within SSIS, as an Execute Process task.

The tool is available on Codeplex under SQL Server 2005 Partition Management