Wednesday, March 07, 2012 8:08 PM
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.
Wednesday, March 07, 2012 8:26 PMModerator
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
- Marked As Answer by Lou8566 Wednesday, March 07, 2012 8:32 PM
Wednesday, March 07, 2012 8:32 PM
Thanks Arthur... I need one of those stables buttons "That was easy"