Date: 20 May 2007
Database Partitions for SSIS is a new Control Flow Task for managing database partitions in SQL Server 2005. Key features are -
- Create partition table based on target table.
- Insert partition table into target table.
- Remove partition from target table.
- Combine smaller partitions into a larger one, for easy backup later.
- Support for ADO.NET, OLEDB, ADO connection managers.
- Easy to use interface. If you know how to use standard SSIS tasks, you will grasp this task immediately.
- Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.