DTSProcessingTask::ProcessingCommands Property
Gets or sets the text of the processing command to be sent to the Analysis Services server.
Assembly: Microsoft.SqlServer.ASTasks (in Microsoft.SqlServer.ASTasks.dll)
Property Value
Type: System::String^The text of the processing command to be sent to the Analysis Services server.
The processing command consists of an XML for Analysis (XMLA) statement that contains the XMLA Batch and Process commands, in a format like the example that follows:
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
<DimensionID>Dim Customer</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Batch>
The following code sample creates, configures, and executes a new DTSProcessingTask that processes the Targeted Mailing mining model in the Adventure Works DW sample database. The sample uses the ProcessingCommands property.