Класс ASExecuteDDLTask

Статья
04/26/2013

Executes Data Definition Language (DDL) commands against an instance of Microsoft SQL Server Службы Analysis Services.

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

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

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

Синтаксис

'Декларация
<GuidAttribute("FCA58F9B-5937-4FCF-B851-8683F7B5A98F")> _
<DtsTaskAttribute(LocalizationType := GetType(ASExecuteDDLTask), UITypeName := "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",  _
    IconResource := "ExecuteTaskIcon")> _
Public Class ASExecuteDDLTask _
    Inherits ASTaskBase _
    Implements IDTSComponentPersist
'Применение
Dim instance As ASExecuteDDLTask

[GuidAttribute("FCA58F9B-5937-4FCF-B851-8683F7B5A98F")]
[DtsTaskAttribute(LocalizationType = typeof(ASExecuteDDLTask), UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ExecuteTaskIcon")]
public class ASExecuteDDLTask : ASTaskBase, 
    IDTSComponentPersist

[GuidAttribute(L"FCA58F9B-5937-4FCF-B851-8683F7B5A98F")]
[DtsTaskAttribute(LocalizationType = typeof(ASExecuteDDLTask), UITypeName = L"Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = L"ExecuteTaskIcon")]
public ref class ASExecuteDDLTask : public ASTaskBase, 
    IDTSComponentPersist

[<GuidAttribute("FCA58F9B-5937-4FCF-B851-8683F7B5A98F")>]
[<DtsTaskAttribute(LocalizationType = typeof(ASExecuteDDLTask), UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=11.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ExecuteTaskIcon")>]
type ASExecuteDDLTask =  
    class 
        inherit ASTaskBase 
        interface IDTSComponentPersist 
    end

public class ASExecuteDDLTask extends ASTaskBase implements IDTSComponentPersist

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

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

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

В начало

Свойства

	Имя	Описание
	ConnectionName	Инфраструктура. Gets or sets the name of the connection for the analysis services task. (Производный от ASTaskBase.)
	ExecutionValue	Gets the result of the Службы Analysis Services Execute DDL task. (Переопределяет Task.ExecutionValue.)
	ProgressEventName	Инфраструктура. Gets the name of the progress event for the analysis services task. (Производный от ASTaskBase.)
	Source	Gets or sets the name of the source that contains the DDL statement to be sent to the Службы Analysis Services server.
	SourceType	Gets or sets a value from the DDLSourceType enumeration indicating the source type that contains the DDL statements.
	StatusEventName	Инфраструктура. Gets the status event name for the Службы Analysis Services Execute DDL task. (Переопределяет ASTaskBase.StatusEventName.)
	SubComponentName	Инфраструктура. Gets the sub component name for the Службы Analysis Services Execute DDL task. (Переопределяет ASTaskBase.SubComponentName.)
	TaskDescription	Gets a description of the Службы Analysis Services Execute DDL task.
	TaskDisplayName	Gets the unique name for the Службы Analysis Services Execute DDL 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.)
	Finalize	(Производный от Object.)
	FireError(String, String)	Инфраструктура. Raises an event when an error occurs. (Производный от ASTaskBase.)
	FireError(Int32, String, String, String)	Инфраструктура. Raises an event when an error occurs. (Производный от 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	Инфраструктура. Executes the DDL task internally. (Переопределяет ASTaskBase.InternalExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
	InternalValidate	Инфраструктура. Validates the DDL task internally. (Переопределяет ASTaskBase.InternalValidate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
	MemberwiseClone	(Производный от Object.)
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
	StopExecution	Инфраструктура. Stops the execution of the analysis service task. (Производный от ASTaskBase.)
	SubscribeToProgressEvent	Инфраструктура. Subscribes the task to progress event. (Производный от ASTaskBase.)
	ToString	(Производный от Object.)
	UnsubscribeToProgressEvent	Инфраструктура. Unsubscribes the task from the progress event. (Производный от 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	Инфраструктура. Validates the analysis service task. (Производный от ASTaskBase.)
	ValidateConnection	Инфраструктура. Validates the task connection. (Производный от ASTaskBase.)
	ValidateDDL	Инфраструктура. Verifies that the DDL task is properly configured. (Переопределяет ASTaskBase.ValidateDDL(VariableDispenser, Connections, Exception%).)
	WriteLog	Инфраструктура. Writes a log for the task. (Производный от ASTaskBase.)

В начало

Поля

	Имя	Описание
	bExecutionCanceled	Инфраструктура. The execution is cancelled. (Производный от ASTaskBase.)
	bTraceError	Инфраструктура. The trace error. (Производный от ASTaskBase.)
	ddl	Инфраструктура. The data definition language. (Производный от ASTaskBase.)
	m_events	Инфраструктура. The events. (Производный от ASTaskBase.)
	server	Инфраструктура. The server. (Производный от ASTaskBase.)

В начало

Примеры

The following code sample creates, configures, and executes a new ASExecuteDDLTask that loads the DDL statement to execute from a file connection.

using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.DataTransformationServices.Tasks.DTSProcessingTask;

class Module1
{

  public static void Main()
  {

    Package pkg = new Package();

    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;";

    ConnectionManager cmdCM;
    cmdCM = pkg.Connections.Add("FILE");
    cmdCM.Name = "Command Source Connection Manager";
    cmdCM.ConnectionString = "C:\\ddltest.txt";

    Executable exe = pkg.Executables.Add("Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask, " +
      "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("SourceType").SetValue(thTask, DDLSourceType.FileConnection);
      thTask.Properties("Source").SetValue(thTask, "Command Source Connection Manager");
    }

    DTSExecResult valResults = pkg.Validate(pkg.Connections, pkg.Variables, null, null);

    if (valResults==DTSExecResult.Success)
    {
      pkg.Execute();
    }

  }

}

Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.DataTransformationServices.Tasks.DTSProcessingTask

Module Module1

  Sub Main()

    Dim pkg As New Package

    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;"

    Dim cmdCM As ConnectionManager
    cmdCM = pkg.Connections.Add("FILE")
    cmdCM.Name = "Command Source Connection Manager"
    cmdCM.ConnectionString = "C:\ddltest.txt"

    Dim exe As Executable = pkg.Executables.Add( _
      "Microsoft.DataTransformationServices.Tasks.DTSProcessingTask.ASExecuteDDLTask, " & _
      "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("SourceType").SetValue(thTask, DDLSourceType.FileConnection)
      .Properties("Source").SetValue(thTask, "Command Source Connection Manager")
    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

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

Класс ASExecuteDDLTask

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

Синтаксис

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

Свойства

Методы

Поля

Примеры

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

См. также

Справочник

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