DTSProcessingTask.ProcessingCommands Property

Definition

Namespace:

Microsoft.DataTransformationServices.Tasks.DTSProcessingTask

Assembly:

Microsoft.SqlServer.ASTasks.dll

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

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

public string ProcessingCommands { get; set; }

member this.ProcessingCommands : string with get, set

Public Property ProcessingCommands As String

Property Value

String

The text of the processing command to be sent to the Analysis Services server.

Examples

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.

using Microsoft.SqlServer.Dts.Runtime;  
using System.Reflection;  

class Module1  
{  

  public static void Main()  
  {  

    Package pkg = new Package();  
    string procCmd;  

    ConnectionManager asCM;  
    asCM = pkg.Connections.Add("MSOLAP100");  
    asCM.Name = "Analysis Services Connection Manager";  
    asCM.ConnectionString = "Data Source=<servername>;" +  
      "Initial Catalog=Adventure Works DW;Provider=MSOLAP;" +  
      "Integrated Security=SSPI;Impersonation Level=Impersonate;";  

    procCmd = "<Batch xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">" +  
      "<Parallel>" +  
        "<Process xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" " +  
            "xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">" +  
          "<Object>" +  
            "<DatabaseID>Adventure Works DW</DatabaseID>" +  
            "<MiningStructureID>Targeted Mailing</MiningStructureID>" +  
          "</Object>" +  
          "<Type>ProcessFull</Type>" +  
          "<WriteBackTableCreation>UseExisting</WriteBackTableCreation>" +  
        "</Process>" +  
      "</Parallel>" +  
    "</Batch>";  

    Executable exe = pkg.Executables.Add("Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask, " +  
      "Microsoft.SqlServer.ASTasks, Version=10.0.0.0, " +  
      "Culture=neutral, PublicKeyToken=89845dcd8080cc91");  
    TaskHost thTask = (TaskHost) exe;  
    {  
      thTask.Properties("ConnectionName").SetValue(thTask, "Analysis Services Connection Manager");  
      thTask.Properties("ProcessingCommands").SetValue(thTask, procCmd);  
    }  

    DTSExecResult valResults = pkg.Validate(pkg.Connections, pkg.Variables, null, null);  

    if (valResults==DTSExecResult.Success)  
    {  
      pkg.Execute();  
    }  

  }  

}  

Imports Microsoft.SqlServer.Dts.Runtime  
Imports System.Reflection  

Module Module1  

  Sub Main()  

    Dim pkg As New Package  
    Dim procCmd As String  

    Dim asCM As ConnectionManager  
    asCM = pkg.Connections.Add("MSOLAP100")  
    asCM.Name = "Analysis Services Connection Manager"  
    asCM.ConnectionString = "Data Source=<servername>;" & _  
      "Initial Catalog=Adventure Works DW;Provider=MSOLAP;" & _  
      "Integrated Security=SSPI;Impersonation Level=Impersonate;"  

    procCmd = "<Batch xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">" & _  
      "<Parallel>" & _  
        "<Process xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" " & _  
            "xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">" & _  
          "<Object>" & _  
            "<DatabaseID>Adventure Works DW</DatabaseID>" & _  
            "<MiningStructureID>Targeted Mailing</MiningStructureID>" & _  
          "</Object>" & _  
          "<Type>ProcessFull</Type>" & _  
          "<WriteBackTableCreation>UseExisting</WriteBackTableCreation>" & _  
        "</Process>" & _  
      "</Parallel>" & _  
    "</Batch>"  

    Dim exe As Executable = pkg.Executables.Add( _  
      "Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask, " & _  
      "Microsoft.SqlServer.ASTasks, Version=10.0.0.0, " & _  
      "Culture=neutral, PublicKeyToken=89845dcd8080cc91")  
    Dim thTask As TaskHost = CType(exe, TaskHost)  
    With thTask  
      .Properties("ConnectionName").SetValue(thTask, _  
        "Analysis Services Connection Manager")  
      .Properties("ProcessingCommands").SetValue(thTask, procCmd)  
    End With  

    Dim valResults As DTSExecResult = pkg.Validate( _  
      pkg.Connections, pkg.Variables, Nothing, Nothing)  

    If valResults = DTSExecResult.Success Then  
      pkg.Execute()  
    End If  

  End Sub  

End Module  

Remarks

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>