Classe ASExecuteDDLTask

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("FC95DF06-8E20-4f90-BFD5-B48AFA59C158")> _
<DtsTaskAttribute(LocalizationType := GetType(ASExecuteDDLTask), UITypeName := "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91",  _
    IconResource := "ExecuteTaskIcon")> _
Public Class ASExecuteDDLTask _
    Inherits ASTaskBase _
    Implements IDTSComponentPersist
'Uso
Dim instance As ASExecuteDDLTask

[GuidAttribute("FC95DF06-8E20-4f90-BFD5-B48AFA59C158")]
[DtsTaskAttribute(LocalizationType = typeof(ASExecuteDDLTask), UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = "ExecuteTaskIcon")]
public class ASExecuteDDLTask : ASTaskBase, 
    IDTSComponentPersist

[GuidAttribute(L"FC95DF06-8E20-4f90-BFD5-B48AFA59C158")]
[DtsTaskAttribute(LocalizationType = typeof(ASExecuteDDLTask), UITypeName = L"Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91", 
    IconResource = L"ExecuteTaskIcon")]
public ref class ASExecuteDDLTask : public ASTaskBase, 
    IDTSComponentPersist

[<GuidAttribute("FC95DF06-8E20-4f90-BFD5-B48AFA59C158")>]
[<DtsTaskAttribute(LocalizationType = typeof(ASExecuteDDLTask), UITypeName = "Microsoft.DataTransformationServices.Tasks.DTSProcessingTaskUI.ASExecuteDDLTaskUI, Microsoft.SqlServer.ASTasksUI, Version=10.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
	ASExecuteDDLTask	Initializes a new instance of the ASExecuteDDLTask class.

Início

Propriedades

	Nome	Descrição
	ConnectionName	Infraestrutura. (Herdado de ASTaskBase.)
	ExecutionValue	Returns the result of the task execution. (Substitui Task. . :: . .ExecutionValue.)
	ProgressEventName	Infraestrutura. (Herdado de ASTaskBase.)
	Source	Gets or sets the text of 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	Infraestrutura. (Substitui ASTaskBase. . :: . .StatusEventName.)
	SubComponentName	Infraestrutura. (Substitui ASTaskBase. . :: . .SubComponentName.)
	TaskDescription	Returns a description of the Analysis Services Execute DDL task.
	TaskDisplayName	Returns the name of the Execute DDL task.
	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
	CanUpdate	*** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Herdado de Task.)
	Equals	Determines whether two object instances are equal. (Herdado de DtsObject.)
	Execute	Infraestrutura. (Herdado de ASTaskBase.)
	Finalize	(Herdado de Object.)
	FireError(String, String)	Infraestrutura. (Herdado de ASTaskBase.)
	FireError(Int32, String, String, String)	Infraestrutura. (Herdado de ASTaskBase.)
	GetConnectionID	Gets a String containing the ID of the connection. (Herdado de Task.)
	GetConnectionName	Gets a String containing the name of the connection. (Herdado de Task.)
	GetHashCode	Returns the hash code for this instance. (Herdado de DtsObject.)
	GetType	(Herdado de Object.)
	InitializeTask	Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Herdado de Task.)
	InternalExecute	Infraestrutura. (Substitui ASTaskBase. . :: . .InternalExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
	InternalValidate	Infraestrutura. (Substitui 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	(Herdado de Object.)
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
	StopExecution	Infraestrutura. (Herdado de ASTaskBase.)
	SubscribeToProgressEvent	Infraestrutura. (Herdado de ASTaskBase.)
	ToString	(Herdado de Object.)
	UnsubscribeToProgressEvent	Infraestrutura. (Herdado de ASTaskBase.)
	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.)
	Validate	Infraestrutura. (Herdado de ASTaskBase.)
	ValidateConnection	Infraestrutura. (Herdado de ASTaskBase.)
	ValidateDDL	Infraestrutura. (Substitui ASTaskBase. . :: . .ValidateDDL(VariableDispenser, Connections, Exception%).)
	WriteLog	Infraestrutura. (Herdado de ASTaskBase.)

Início

Campos

	Nome	Descrição
	bExecutionCanceled	Infraestrutura. (Herdado de ASTaskBase.)
	bTraceError	Infraestrutura. (Herdado de ASTaskBase.)
	ddl	Infraestrutura. (Herdado de ASTaskBase.)
	m_events	Infraestrutura. (Herdado de ASTaskBase.)
	server	Infraestrutura. (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