Partition Management Utility v 2.0

Question

I would like to use the CodePlex project Partition Management Utility 2.0 http://sqlpartitionmgmt.codeplex.com/

The utility must be run from the command line or within an SSIS package.  Command line parameters determine behavior.  You may perform one of five different functions depending on the COMMAND parameter.  Additional parameters define the connection (server, integrated security, etc); database, schema, partitioned table name, etc.  You have the option of identifying a partition to manage either by explicit partition number (/p:) OR by specifying a string representation of a value that can be input to the partition range function to determine a partition number (/v:).

How do I execute PartitionManagement.exe from within an SSIS Package?

The command line that i would like to run is:

ManagePartition.exe /C:ClearPartition  /d:MDWT_Sample /s:dbo /t:FactInternetSales /v:20110501

Thanks in advance.

Also if there are any SSIS package examples that implement the PartitionManagement.exe available that would be appreciated.

---

Lou

Answer 1

Hi Lou,

In your package in the tollbox, one of the items is called Execute Process task, drag and drop it to your designer surface, double-click it and then put this command line in.

See more info here: http://msdn.microsoft.com/en-us/library/ms141166.aspx

---

Arthur My Blog

Answer 2

Thanks Arthur... I need one of those stables buttons "That was easy"

---

Lou