Analysis Services Execute DDL Task Editor (DDL Page)

 

Applies To: SQL Server 2016

Use the DDL page of the Analysis Services Execute DDL Task Editor dialog box to specify a connection to an Analysis Services project or an Analysis Services database and to provide information about the source of data definition language (DDL) statements.

To learn about this task, see Analysis Services Execute DDL Task.

Connection
Select an Analysis Services project or an Analysis Services connection manager in the list, or click <New connection...> and use the Add Analysis Services Connection Manager dialog box to create a new connection.

Related Topics: Add Analysis Services Connection Manager Dialog Box UI Reference, Analysis Services Connection Manager

SourceType
Specify the source type of the DDL statements. This property has the options listed in the following table:

ValueDescription
Direct InputSet the source to the DDL statement stored in the SourceDirect text box. Selecting this value displays the dynamic options in the following section.
File ConnectionSet the source to a file that contains the DDL statement. Selecting this value displays the dynamic options in the following section.
VariableSet the source to a variable. Selecting this value displays the dynamic options in the following section.

SourceType = Direct Input

Source
Type the DDL statements or click the ellipsis (…) and then type the statements in the DDL Statements dialog box.

SourceType = File Connection

Source
Select a File connection in the list, or click <New connection...> and use the File Connection Manager dialog box to create a new connection.

Related Topics: File Connection Manager

SourceType = Variable

Source
Select a variable in the list, or click <New variable...> and use the Add Variable dialog box to create a new variable.

Related Topics: Integration Services (SSIS) Variables

Integration Services Error and Message Reference
Analysis Services Execute DDL Task Editor (General Page)
Expressions Page
Control Flow
Analysis Services Scripting Language (ASSL for XMLA)
XML for Analysis (XMLA) Reference

Community Additions

ADD
Show: