Статья
04/01/2012

Класс DTSProcessingTask

Processes objects in a Microsoft SQL Server Службы Analysis Services database.

Иерархия наследования

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

Пространство имен: Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Сборка: Microsoft.SqlServer.ASTasks (в Microsoft.SqlServer.ASTasks.dll)

Синтаксис

'Декларация
<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
'Применение
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

Тип DTSProcessingTask обеспечивает доступ к следующим элементам.

Конструкторы

	Имя	Описание
	DTSProcessingTask	Initializes a new instance of the DTSProcessingTask class.

В начало

Свойства

	Имя	Описание
	ConnectionName	Инфраструктура. (Производный от ASTaskBase.)
	ExecutionValue	Returns a user-defined object. This field is read-only. (Производный от Task.)
	ProcessingCommands	Gets or sets the text of the processing command to be sent to the Службы Analysis Services server.
	ProgressEventName	Инфраструктура. (Производный от ASTaskBase.)
	StatusEventName	Инфраструктура. (Производный от ASTaskBase.)
	SubComponentName	Инфраструктура. (Производный от 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. (Производный от Task.)

В начало

Методы

	Имя	Описание
	CanUpdate	* Member deprecated; see Remarks. * A Boolean that indicates whether the new package XML can update the old package XML. (Производный от Task.)
	Equals	Determines whether two object instances are equal. (Производный от DtsObject.)
	Execute	Инфраструктура. (Производный от ASTaskBase.)
	Finalize	(Производный от Object.)
	FireError(String, String)	Инфраструктура. (Производный от ASTaskBase.)
	FireError(Int32, String, String, String)	Инфраструктура. (Производный от ASTaskBase.)
	GetConnectionID	Gets a String containing the ID of the connection. (Производный от Task.)
	GetConnectionName	Gets a String containing the name of the connection. (Производный от Task.)
	GetHashCode	Returns the hash code for this instance. (Производный от DtsObject.)
	GetType	(Производный от Object.)
	InitializeTask	Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Производный от Task.)
	InternalExecute	Инфраструктура. (Производный от ASTaskBase.)
	InternalValidate	Инфраструктура. (Производный от 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	(Производный от 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	Инфраструктура. (Производный от ASTaskBase.)
	SubscribeToProgressEvent	Инфраструктура. (Производный от ASTaskBase.)
	ToString	(Производный от Object.)
	UnsubscribeToProgressEvent	Инфраструктура. (Производный от ASTaskBase.)
	Update	* Member deprecated; see Remarks. * This method updates the old package XML with the new package XML if CanUpdate is set to true. (Производный от Task.)
	Validate	Инфраструктура. (Производный от ASTaskBase.)
	ValidateConnection	Инфраструктура. (Производный от ASTaskBase.)
	ValidateDDL	Инфраструктура. (Производный от ASTaskBase.)
	WriteLog	Инфраструктура. (Производный от ASTaskBase.)

В начало

Поля

	Имя	Описание
	bExecutionCanceled	Инфраструктура. (Производный от ASTaskBase.)
	bTraceError	Инфраструктура. (Производный от ASTaskBase.)
	ddl	Инфраструктура. (Производный от ASTaskBase.)
	m_events	Инфраструктура. (Производный от ASTaskBase.)
	server	Инфраструктура. (Производный от ASTaskBase.)

В начало

Примеры

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

Безопасность многопоточности

Любые открытые статический (Shared в Visual Basic) элементы этого типа потокобезопасны. Потокобезопасность с элементами экземпляров не гарантируется.

См. также

Справочник

Пространство имен Microsoft.DataTransformationServices.Tasks.DTSProcessingTask

Поделиться через

Класс DTSProcessingTask

Иерархия наследования

Синтаксис

Конструкторы

Свойства

Методы

Поля

Примеры

Безопасность многопоточности

См. также

Справочник

Дополнительные ресурсы