Classe DTSProcessingTask

Processes objects in a Microsoft SQL Server Analysis Services database.

Hierarquia de herança

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

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

Sintaxe

'Declaração
<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
'Uso
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

O tipo DTSProcessingTask expõe os membros a seguir.

Construtores

	Nome	Descrição
	DTSProcessingTask	Initializes a new instance of the DTSProcessingTask class.

Início

Propriedades

	Nome	Descrição
	ConnectionName	Infraestrutura. (Herdado de ASTaskBase.)
	ExecutionValue	Returns a user-defined object. This field is read-only. (Herdado de Task.)
	ProcessingCommands	Gets or sets the text of the processing command to be sent to the Analysis Services server.
	ProgressEventName	Infraestrutura. (Herdado de ASTaskBase.)
	StatusEventName	Infraestrutura. (Herdado de ASTaskBase.)
	SubComponentName	Infraestrutura. (Herdado de ASTaskBase.)
	TaskDescription	Gets the description of the Analysis Services Processing task.
	TaskDisplayName	Gets the unique name for the Analysis Services Processing task.
	Version	*** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Herdado de Task.)

Início

Métodos

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

Início

Campos

	Nome	Descrição
	bExecutionCanceled	Infraestrutura. (Herdado de ASTaskBase.)
	bTraceError	Infraestrutura. (Herdado de ASTaskBase.)
	ddl	Infraestrutura. (Herdado de ASTaskBase.)
	m_events	Infraestrutura. (Herdado de ASTaskBase.)
	server	Infraestrutura. (Herdado de ASTaskBase.)

Início

Exemplos

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

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.DataTransformationServices.Tasks.DTSProcessingTask