ASExecuteDDLTask-Klasse

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

Vererbungshierarchie

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 (in Microsoft.SqlServer.ASTasks.dll)

Syntax

'Declaration
<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
'Usage
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

Der ASExecuteDDLTask-Typ macht folgende Elemente verfügbar.

Konstruktoren

	Name	Beschreibung
	ASExecuteDDLTask	Initializes a new instance of the ASExecuteDDLTask class.

Zum Anfang

Eigenschaften

	Name	Beschreibung
	ConnectionName	Infrastruktur (Geerbt von ASTaskBase.)
	ExecutionValue	Returns the result of the task execution. (Überschreibt Task. . :: . .ExecutionValue.)
	ProgressEventName	Infrastruktur (Geerbt von 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	Infrastruktur (Überschreibt ASTaskBase. . :: . .StatusEventName.)
	SubComponentName	Infrastruktur (Überschreibt 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. (Geerbt von Task.)

Zum Anfang

Methoden

	Name	Beschreibung
	CanUpdate	*** Member deprecated; see Remarks. ***    A Boolean that indicates whether the new package XML can update the old package XML. (Geerbt von Task.)
	Equals	Determines whether two object instances are equal. (Geerbt von DtsObject.)
	Execute	Infrastruktur (Geerbt von ASTaskBase.)
	Finalize	(Geerbt von Object.)
	FireError(String, String)	Infrastruktur (Geerbt von ASTaskBase.)
	FireError(Int32, String, String, String)	Infrastruktur (Geerbt von ASTaskBase.)
	GetConnectionID	Gets a String containing the ID of the connection. (Geerbt von Task.)
	GetConnectionName	Gets a String containing the name of the connection. (Geerbt von Task.)
	GetHashCode	Returns the hash code for this instance. (Geerbt von DtsObject.)
	GetType	(Geerbt von Object.)
	InitializeTask	Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Geerbt von Task.)
	InternalExecute	Infrastruktur (Überschreibt ASTaskBase. . :: . .InternalExecute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).)
	InternalValidate	Infrastruktur (Überschreibt 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	(Geerbt von Object.)
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
	StopExecution	Infrastruktur (Geerbt von ASTaskBase.)
	SubscribeToProgressEvent	Infrastruktur (Geerbt von ASTaskBase.)
	ToString	(Geerbt von Object.)
	UnsubscribeToProgressEvent	Infrastruktur (Geerbt von ASTaskBase.)
	Update	*** Member deprecated; see Remarks. ***    This method updates the old package XML with the new package XML if CanUpdate is set to true. (Geerbt von Task.)
	Validate	Infrastruktur (Geerbt von ASTaskBase.)
	ValidateConnection	Infrastruktur (Geerbt von ASTaskBase.)
	ValidateDDL	Infrastruktur (Überschreibt ASTaskBase. . :: . .ValidateDDL(VariableDispenser, Connections, Exception%).)
	WriteLog	Infrastruktur (Geerbt von ASTaskBase.)

Zum Anfang

Felder

	Name	Beschreibung
	bExecutionCanceled	Infrastruktur (Geerbt von ASTaskBase.)
	bTraceError	Infrastruktur (Geerbt von ASTaskBase.)
	ddl	Infrastruktur (Geerbt von ASTaskBase.)
	m_events	Infrastruktur (Geerbt von ASTaskBase.)
	server	Infrastruktur (Geerbt von ASTaskBase.)

Zum Anfang

Beispiele

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

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.DataTransformationServices.Tasks.DTSProcessingTask-Namespace