DTSProcessingTask::ProcessingCommands Property

 

Gets or sets the text of the processing command to be sent to the Analysis Services server.

Namespace:   Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Assembly:  Microsoft.SqlServer.ASTasks (in Microsoft.SqlServer.ASTasks.dll)

public:
property String^ ProcessingCommands {
	String^ get();
	void set(String^ value);
}

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.

No code example is currently available or this language may not be supported.
Return to top
Show: