Compartir a través de

Clase ASExecuteDDLTask

  • Artículo

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

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.DataTransformationServices.Tasks.DTSProcessingTask
Ensamblado:  Microsoft.SqlServer.ASTasks (en Microsoft.SqlServer.ASTasks.dll)

Sintaxis

'Declaración
<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

El tipo ASExecuteDDLTask expone los siguientes miembros.

Constructores

  Nombre Descripción
Método público ASExecuteDDLTask Creates a new instance of the ASExecuteDDLTask class.

Arriba

Propiedades

  Nombre Descripción
Propiedad pública ConnectionName Infraestructura. Gets or sets the name of the connection for the analysis services task. (Se hereda de ASTaskBase.)
Propiedad pública ExecutionValue Gets the result of the Analysis Services Execute DDL task. (Invalida Task.ExecutionValue.)
Propiedad protegida ProgressEventName Infraestructura. Gets the name of the progress event for the analysis services task. (Se hereda de ASTaskBase.)
Propiedad pública Source Gets or sets the name of the source that contains the DDL statement to be sent to the Analysis Services server.
Propiedad pública SourceType Gets or sets a value from the DDLSourceType enumeration indicating the source type that contains the DDL statements.
Propiedad protegida StatusEventName Infraestructura. Gets the status event name for the Analysis Services Execute DDL task. (Invalida ASTaskBase.StatusEventName.)
Propiedad protegida SubComponentName Infraestructura. Gets the sub component name for the Analysis Services Execute DDL task. (Invalida ASTaskBase.SubComponentName.)
Propiedad públicaMiembro estático TaskDescription Gets a description of the Analysis Services Execute DDL task.
Propiedad públicaMiembro estático TaskDisplayName Gets the unique name for the Analysis Services Execute DDL task.
Propiedad pública Version *** Member deprecated; see Remarks. ***    Returns the version of the task. This property is read-only. (Se hereda de Task.)

Arriba

Métodos

  Nombre Descripción
Método público CanUpdate *** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Se hereda de Task.)
Método público Equals Determines whether two object instances are equal. (Se hereda de DtsObject.)
Método público Execute Infraestructura. Executes the analysis services task. (Se hereda de ASTaskBase.)
Método protegido Finalize (Se hereda de Object.)
Método protegido FireError(String, String) Infraestructura. Raises an event when an error occurs. (Se hereda de ASTaskBase.)
Método protegido FireError(Int32, String, String, String) Infraestructura. Raises an event when an error occurs. (Se hereda de ASTaskBase.)
Método público GetConnectionID Gets a String containing the ID of the connection. (Se hereda de Task.)
Método público GetConnectionName Gets a String containing the name of the connection. (Se hereda de Task.)
Método público GetHashCode Returns the hash code for this instance. (Se hereda de DtsObject.)
Método público GetType (Se hereda 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. (Se hereda de Task.)
Método protegido InternalExecute Infraestructura. Executes the DDL task internally. (Invalida ASTaskBase.InternalExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
Método protegido InternalValidate Infraestructura. Validates the DDL task internally. (Invalida 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 (Se hereda 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 Infraestructura. Stops the execution of the analysis service task. (Se hereda de ASTaskBase.)
Método protegido SubscribeToProgressEvent Infraestructura. Subscribes the task to progress event. (Se hereda de ASTaskBase.)
Método público ToString (Se hereda de Object.)
Método protegido UnsubscribeToProgressEvent Infraestructura. Unsubscribes the task from the progress event. (Se hereda 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. (Se hereda de Task.)
Método público Validate Infraestructura. Validates the analysis service task. (Se hereda de ASTaskBase.)
Método protegido ValidateConnection Infraestructura. Validates the task connection. (Se hereda de ASTaskBase.)
Método protegido ValidateDDL Infraestructura. Verifies that the DDL task is properly configured. (Invalida ASTaskBase.ValidateDDL(VariableDispenser, Connections, Exception%).)
Método protegido WriteLog Infraestructura. Writes a log for the task. (Se hereda de ASTaskBase.)

Arriba

Campos

  Nombre Descripción
Campo protegido bExecutionCanceled Infraestructura. The execution is cancelled. (Se hereda de ASTaskBase.)
Campo protegido bTraceError Infraestructura. The trace error. (Se hereda de ASTaskBase.)
Campo protegido ddl Infraestructura. The data definition language. (Se hereda de ASTaskBase.)
Campo protegido m_events Infraestructura. The events. (Se hereda de ASTaskBase.)
Campo protegido server Infraestructura. The server. (Se hereda de ASTaskBase.)

Arriba

Ejemplos

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

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.DataTransformationServices.Tasks.DTSProcessingTask