SQLDTS.comSQLIS.comSQLIS Wiki
News & Resources
Date: 20 May 2007
Source: SQLIS.com

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.
Full story...