DataSource (Decision Support Objects)


  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The DataSource object in Decision Support Objects (DSO) provides access to the data sources associated with a database, cube, partition, or aggregation in Microsoft® SQL Server™ 2005 Analysis Services, under the DataSources collection for each DSO object. The DataSource object uses the DataSource interface, with a ClassType property of clsDataSource.

The DataSource object is used to:

  • Retrieve data source-specific information such as connection strings and quote characters for use by client applications.

  • Determine various states, such as connection state, of the data source in Analysis Services.