DTSProcessingTask 类

项目
04/26/2013

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 中）

语法

声明
<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
用法
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

DTSProcessingTask 类型公开以下成员。

构造函数

	名称	说明
	DTSProcessingTask	Initializes a new instance of the DTSProcessingTask class.

页首

属性

	名称	说明
	ConnectionName	基础结构。Gets or sets the name of the connection for the analysis services task. （从 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.
	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	基础结构。Executes the analysis services task. （从 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 继承。）
	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.
	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.
	ToString	（从 Object 继承。）
	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	基础结构。Validates the analysis service task. （从 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 类

继承层次结构

语法

构造函数

属性

方法

示例

线程安全

请参阅

参考

其他资源