Compartilhar via

Classe ASExecuteDDLTask

  • Artigo

Executes Data Definition Language (DDL) commands against an instance of Microsoft SQL Server Analysis Services.

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.ASExecuteDDLTask

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

Sintaxe

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

O tipo ASExecuteDDLTask expõe os membros a seguir.

Construtores

  Nome Descrição
Método público ASExecuteDDLTask Creates a new instance of the ASExecuteDDLTask class.

Início

Propriedades

  Nome Descrição
Propriedade pública ConnectionName Infraestrutura. Gets or sets the name of the connection for the analysis services task. (Herdado de ASTaskBase.)
Propriedade pública ExecutionValue Gets the result of the Analysis Services Execute DDL task. (Substitui Task.ExecutionValue.)
Propriedade protegida ProgressEventName Infraestrutura. Gets the name of the progress event for the analysis services task. (Herdado de ASTaskBase.)
Propriedade pública Source Gets or sets the name of the source that contains the DDL statement to be sent to the Analysis Services server.
Propriedade pública SourceType Gets or sets a value from the DDLSourceType enumeration indicating the source type that contains the DDL statements.
Propriedade protegida StatusEventName Infraestrutura. Gets the status event name for the Analysis Services Execute DDL task. (Substitui ASTaskBase.StatusEventName.)
Propriedade protegida SubComponentName Infraestrutura. Gets the sub component name for the Analysis Services Execute DDL task. (Substitui ASTaskBase.SubComponentName.)
Propriedade públicaMembro estático TaskDescription Gets a description of the Analysis Services Execute DDL task.
Propriedade públicaMembro estático TaskDisplayName Gets the unique name for the Analysis Services Execute DDL task.
Propriedade pública 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
Método público CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Herdado de Task.)
Método público Equals Determines whether two object instances are equal. (Herdado de DtsObject.)
Método público Execute Infraestrutura. Executes the analysis services task. (Herdado de ASTaskBase.)
Método protegido Finalize (Herdado de Object.)
Método protegido FireError(String, String) Infraestrutura. Raises an event when an error occurs. (Herdado de ASTaskBase.)
Método protegido FireError(Int32, String, String, String) Infraestrutura. Raises an event when an error occurs. (Herdado de ASTaskBase.)
Método público GetConnectionID Gets a String containing the ID of the connection. (Herdado de Task.)
Método público GetConnectionName Gets a String containing the name of the connection. (Herdado de Task.)
Método público GetHashCode Returns the hash code for this instance. (Herdado de DtsObject.)
Método público GetType (Herdado de Object.)
Método público InitializeTask Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Herdado de Task.)
Método protegido InternalExecute Infraestrutura. Executes the DDL task internally. (Substitui ASTaskBase.InternalExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Método protegido InternalValidate Infraestrutura. Validates the DDL task internally. (Substitui ASTaskBase.InternalValidate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).)
Método público LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Método protegido MemberwiseClone (Herdado de Object.)
Método público SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
Método protegido StopExecution Infraestrutura. Stops the execution of the analysis service task. (Herdado de ASTaskBase.)
Método protegido SubscribeToProgressEvent Infraestrutura. Subscribes the task to progress event. (Herdado de ASTaskBase.)
Método público ToString (Herdado de Object.)
Método protegido UnsubscribeToProgressEvent Infraestrutura. Unsubscribes the task from the progress event. (Herdado de ASTaskBase.)
Método público 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.)
Método público Validate Infraestrutura. Validates the analysis service task. (Herdado de ASTaskBase.)
Método protegido ValidateConnection Infraestrutura. Validates the task connection. (Herdado de ASTaskBase.)
Método protegido ValidateDDL Infraestrutura. Verifies that the DDL task is properly configured. (Substitui ASTaskBase.ValidateDDL(VariableDispenser, Connections, Exception%).)
Método protegido WriteLog Infraestrutura. Writes a log for the task. (Herdado de ASTaskBase.)

Início

Campos

  Nome Descrição
Campo protegido bExecutionCanceled Infraestrutura. The execution is cancelled. (Herdado de ASTaskBase.)
Campo protegido bTraceError Infraestrutura. The trace error. (Herdado de ASTaskBase.)
Campo protegido ddl Infraestrutura. The data definition language. (Herdado de ASTaskBase.)
Campo protegido m_events Infraestrutura. The events. (Herdado de ASTaskBase.)
Campo protegido server Infraestrutura. The server. (Herdado de ASTaskBase.)

Início

Exemplos

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

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