SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Integration Services

Technical Reference

Feature Reference

Integration Services F1 Help

SSIS Designer F1 Help

Task Properties UI Reference

ActiveX Script Task Editor (General Page)

ActiveX Script Task Editor (Script Page)

Analysis Services Execute DDL Task Editor (General Page)

Analysis Services Execute DDL Task Editor (DDL Page)

Analysis Services Processing Task Editor (General Page)

Analysis Services Processing Task Editor (Analysis Services Page)

Bulk Insert Task Editor (General Page)

Bulk Insert Task Editor (Connection Page)

Bulk Insert Task Editor (Options Page)

Data Mining Query Task Editor (Mining Model Tab)

Data Mining Query Task Editor (Query Tab)

Data Mining Query Task Editor (Output Tab)

Data Profiling Task Editor (General Page)

Single Table Quick Profile Form (Data Profiling Task)

Data Profiling Task Editor (Profile Requests Page)

Destination Database Files

Execute DTS 2000 Package Task Editor (General Page)

Execute DTS 2000 Package Task Editor (Inner Variables Page)

Execute DTS 2000 Package Task Editor (Outer Variables Page)

Execute Package Task Editor (General Page)

Execute Package Task Editor (Package Page)

Execute Process Task Editor (General Page)

Execute Process Task Editor (Process Page)

Execute SQL Task Editor (General Page)

Execute SQL Task Editor (Parameter Mapping Page)

Execute SQL Task Editor (Result Set Page)

File System Task Editor (General Page)

FTP Task Editor (General Page)

FTP Task Editor (File Transfer Page)

Message Queue Task Editor (General Page)

Message Queue Task Editor (Receive Page)

Message Queue Task Editor (Send Page)

Script Task Editor (General Page)

Script Task Editor (Script Page)

Select Objects to Transfer

Select Variables Page

Send Mail Task Editor (General Page)

Send Mail Task Editor (Mail Page)

Source database files

Transfer Database Task Editor (General Page)

Transfer Database Task Editor (Databases Page)

Transfer Error Messages Task Editor (General Page)

Transfer Error Messages Task Editor (Messages Page)

Transfer Jobs Task Editor (General Page)

Transfer Jobs Task Editor (Jobs Page)

Transfer Logins Task Editor (General Page)

Transfer Logins Task Editor (Logins Page)

Transfer SQL Server Objects Task Editor (General Page)

Transfer SQL Server Objects Task Editor (Objects Page)

Transfer Master Stored Procedures Task Editor (General Page)

Transfer Master Stored Procedures Task Editor (Stored Procedures Page)

Web Service Task Editor (General Page)

Web Service Task Editor (Input Page)

Web Service Task Editor (Output Page)

WMI Data Reader Task Editor (General Page)

WMI Data Reader Task Editor (WMI Options Page)

WMI Event Watcher Task Editor (General Page)

WMI Event Watcher Task Editor (WMI Options Page)

XML Task Editor (General Page)

Minimize

This topic has not yet been rated - Rate this topic

Analysis Services Execute DDL Task Editor (DDL Page)

SQL Server 2008 R2

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, Analysis Services Connection Manager

SourceType

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

Value	Description
Direct Input	Set the source to the DDL statement stored in the SourceDirect text box. Selecting this value displays the dynamic options in the following section.
File Connection	Set the source to a file that contains the DDL statement. Selecting this value displays the dynamic options in the following section.
Variable	Set the source to a variable. Selecting this value displays the dynamic options in the following section.

Dynamic Options

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 Variables

Reference

Analysis Services Execute DDL Task Editor (General Page)

Expressions Page

Concepts

SSIS Error and Message Reference

Designing Package Control Flow

Analysis Services Scripting Language Reference

Other Resources

XML for Analysis Reference (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.