DataSource Data Type (ASSL)

Defines an abstract primitive data type that represents a data source in a Database element.

Syntax

<DataSource>
   <Name>...</Name>
   <ID>...</ID>
   <CreatedTimestamp>...</CreateTimestamp>
   <LastSchemaUpdate>...</LastSchemaUpdate>
   <ManagedProvider>...</ManagedProvider>
   <ConnectionString>...</ConnectionString>
   <ConnectionStringSecurity>...</ConnectionStringSecurity>
   <ImpersonationInfo>...</ImpersonationInfo>
   <Isolation>...</Isolation>
   <MaxActiveConnections>...</MaxActiveConnections>
   <Description>...</Description>
   <Timeout>...</Timeout>
   <Annotations>...</Annotations>
   <DataSourcePermission>...</DataSourcePermission>
</DataSource>

Data Type Characteristics

Characteristic Description

Base data types

None

Derived data types

RelationalDataSource, OlapDataSource, PushedDataSource

Data Type Relationships

Relationship Element

Parent elements

None

Child elements

Annotations, ConnectionString, ConnectionStringSecurity, CreatedTimestamp, DataSourcePermission, Description, ID, ImpersonationInfo, Isolation, LastSchemaUpdate, ManagedProvider, MaxActiveConnections, Name, Timeout

Derived elements

None

Remarks

When defining out-of-line bindings, the Name element is optional. Not having to specify a Name element allows data sources to be defined within the binding for cubes, partitions, and so on. For data sources contained by a Database element, Name is a required element.

For more information about data sources, see Data Sources (Analysis Services).

The corresponding element in the Analysis Management Objects (AMO) object model is DataSource.

See Also

Reference

Analysis Services Scripting Language XML Data Types (ASSL)

Help and Information

Getting SQL Server 2005 Assistance