發行項
04/02/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

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.DataTransformationServices.Tasks.DTSProcessingTask 命名空間

共用方式為

DTSProcessingTask 類別

繼承階層

語法

建構函式

屬性

方法

欄位

範例

執行緒安全性

請參閱

參考

其他資源