Partager via


Classe DTSProcessingTask

Processes objects in a Microsoft SQL Server Analysis Services database.

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Assembly :  Microsoft.SqlServer.ASTasks (en Microsoft.SqlServer.ASTasks.dll)

Syntaxe

'Déclaration
<DtsTaskAttribute(LocalizationType := GetType(DTSProcessingTask), TaskType := "DTS90",  _
    UITypeName := "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",  _
    IconResource := "ProcessTaskIcon")> _
<GuidAttribute("BB85884C-3512-450f-9DB6-1AEDE8284283")> _
Public NotInheritable Class DTSProcessingTask _
    Inherits ASTaskBase _
    Implements IDTSComponentPersist
'Utilisation
Dim instance As DTSProcessingTask
[DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = "DTS90", 
    UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ProcessTaskIcon")]
[GuidAttribute("BB85884C-3512-450f-9DB6-1AEDE8284283")]
public sealed class DTSProcessingTask : ASTaskBase, 
    IDTSComponentPersist
[DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = L"DTS90", 
    UITypeName = L"Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = L"ProcessTaskIcon")]
[GuidAttribute(L"BB85884C-3512-450f-9DB6-1AEDE8284283")]
public ref class DTSProcessingTask sealed : public ASTaskBase, 
    IDTSComponentPersist
[<SealedAttribute>]
[<DtsTaskAttribute(LocalizationType = typeof(DTSProcessingTask), TaskType = "DTS90", 
    UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.DTSProcessingTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ProcessTaskIcon")>]
[<GuidAttribute("BB85884C-3512-450f-9DB6-1AEDE8284283")>]
type DTSProcessingTask =  
    class
        inherit ASTaskBase
        interface IDTSComponentPersist
    end
public final class DTSProcessingTask extends ASTaskBase implements IDTSComponentPersist

Le type DTSProcessingTask expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique DTSProcessingTask Initializes a new instance of the DTSProcessingTask class.

Haut de la page

Propriétés

  Nom Description
Propriété publique ConnectionName Infrastructure. (hérité de ASTaskBase.)
Propriété publique ExecutionValue Returns a user-defined object. This field is read-only. (hérité de Task.)
Propriété publique ProcessingCommands Gets or sets the text of the processing command to be sent to the Analysis Services server.
Propriété protégée ProgressEventName Infrastructure. (hérité de ASTaskBase.)
Propriété protégée StatusEventName Infrastructure. (hérité de ASTaskBase.)
Propriété protégée SubComponentName Infrastructure. (hérité de ASTaskBase.)
Propriété publiqueMembre statique TaskDescription Gets the description of the Analysis Services Processing task.
Propriété publiqueMembre statique TaskDisplayName Gets the unique name for the Analysis Services Processing task.
Propriété publique Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (hérité de Task.)

Haut de la page

Méthodes

  Nom Description
Méthode publique CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (hérité de Task.)
Méthode publique Equals Determines whether two object instances are equal. (hérité de DtsObject.)
Méthode publique Execute Infrastructure. (hérité de ASTaskBase.)
Méthode protégée Finalize (hérité de Object.)
Méthode protégée FireError(String, String) Infrastructure. (hérité de ASTaskBase.)
Méthode protégée FireError(Int32, String, String, String) Infrastructure. (hérité de ASTaskBase.)
Méthode publique GetConnectionID Gets a String containing the ID of the connection. (hérité de Task.)
Méthode publique GetConnectionName Gets a String containing the name of the connection. (hérité de Task.)
Méthode publique GetHashCode Returns the hash code for this instance. (hérité de DtsObject.)
Méthode publique GetType (hérité de Object.)
Méthode publique InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (hérité de Task.)
Méthode protégée InternalExecute Infrastructure. (hérité de ASTaskBase.)
Méthode protégée InternalValidate Infrastructure. (hérité de ASTaskBase.)
Méthode publique 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éthode protégée MemberwiseClone (hérité de Object.)
Méthode publique 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éthode protégée StopExecution Infrastructure. (hérité de ASTaskBase.)
Méthode protégée SubscribeToProgressEvent Infrastructure. (hérité de ASTaskBase.)
Méthode publique ToString (hérité de Object.)
Méthode protégée UnsubscribeToProgressEvent Infrastructure. (hérité de ASTaskBase.)
Méthode publique Update *** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (hérité de Task.)
Méthode publique Validate Infrastructure. (hérité de ASTaskBase.)
Méthode protégée ValidateConnection Infrastructure. (hérité de ASTaskBase.)
Méthode protégée ValidateDDL Infrastructure. (hérité de ASTaskBase.)
Méthode protégée WriteLog Infrastructure. (hérité de ASTaskBase.)

Haut de la page

Champs

  Nom Description
Champ protégé bExecutionCanceled Infrastructure. (hérité de ASTaskBase.)
Champ protégé bTraceError Infrastructure. (hérité de ASTaskBase.)
Champ protégé ddl Infrastructure. (hérité de ASTaskBase.)
Champ protégé m_events Infrastructure. (hérité de ASTaskBase.)
Champ protégé server Infrastructure. (hérité de ASTaskBase.)

Haut de la page

Exemples

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

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.