Compartir a través de

Clase DTSProcessingTask

  • Artículo

Processes objects in a Microsoft SQL Server Analysis Services database.

Jerarquía de herencia

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASTaskBase
        Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.DTSProcessingTask

Espacio de nombres:  Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Ensamblado:  Microsoft.SqlServer.ASTasks (en Microsoft.SqlServer.ASTasks.dll)

Sintaxis

'Declaración
<GuidAttribute("517E3B72-5720-4B6C-B5A1-0D20B8339BA1")> _
<DtsTaskAttribute(LocalizationType := GetType(DTSProcessingTask), TaskType := "DTS90",  _
    UITypeName := "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",  _
    IconResource := "ProcessTaskIcon")> _
Public NotInheritable Class DTSProcessingTask _
    Inherits ASTaskBase _
    Implements IDTSComponentPersist
'Uso
Dim instance As DTSProcessingTask

[GuidAttribute("517E3B72-5720-4B6C-B5A1-0D20B8339BA1")]
[DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = "DTS90", 
    UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ProcessTaskIcon")]
public sealed class DTSProcessingTask : ASTaskBase, 
    IDTSComponentPersist

[GuidAttribute(L"517E3B72-5720-4B6C-B5A1-0D20B8339BA1")]
[DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = L"DTS90", 
    UITypeName = L"Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = L"ProcessTaskIcon")]
public ref class DTSProcessingTask sealed : public ASTaskBase, 
    IDTSComponentPersist

[<SealedAttribute>]
[<GuidAttribute("517E3B72-5720-4B6C-B5A1-0D20B8339BA1")>]
[<DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = "DTS90", 
    UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ProcessTaskIcon")>]
type DTSProcessingTask =  
    class 
        inherit ASTaskBase 
        interface IDTSComponentPersist 
    end

public final class DTSProcessingTask extends ASTaskBase implements IDTSComponentPersist

El tipo DTSProcessingTask expone los siguientes miembros.

Constructores

  Nombre Descripción
Método público DTSProcessingTask Initializes a new instance of the DTSProcessingTask class.

Arriba

Propiedades

  Nombre Descripción
Propiedad pública ConnectionName Infraestructura. Gets or sets the name of the connection for the analysis services task. (Se hereda de ASTaskBase.)
Propiedad pública ExecutionValue Returns a user-defined object. This field is read-only. (Se hereda de Task.)
Propiedad pública ProcessingCommands Gets or sets the text of the processing command to be sent to the Analysis Services server.
Propiedad públicaMiembro estático TaskDescription Gets the description of the Analysis Services Processing task.
Propiedad públicaMiembro estático TaskDisplayName Gets the unique name for the Analysis Services Processing task.
Propiedad pública Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Se hereda de Task.)

Arriba

Métodos

  Nombre Descripción
Método público CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Se hereda de Task.)
Método público Equals Determines whether two object instances are equal. (Se hereda de DtsObject.)
Método público Execute Infraestructura. Executes the analysis services task. (Se hereda de ASTaskBase.)
Método público GetConnectionID Gets a String containing the ID of the connection. (Se hereda de Task.)
Método público GetConnectionName Gets a String containing the name of the connection. (Se hereda de Task.)
Método público GetHashCode Returns the hash code for this instance. (Se hereda de DtsObject.)
Método público GetType (Se hereda de Object.)
Método público InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Se hereda de Task.)
Método público LoadFromXML Loads the task information from XML. This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Método público SaveToXML Saves component information to the package XML. This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Método público ToString (Se hereda de Object.)
Método público Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Se hereda de Task.)
Método público Validate Infraestructura. Validates the analysis service task. (Se hereda de ASTaskBase.)

Arriba

Ejemplos

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.

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=\"https://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 https://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

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.DataTransformationServices.Tasks.DTSProcessingTask