DataSources Collection


  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.

A DataSources collection in a Decision Support Objects (DSO) object contains the data sources that are or can be used by the subordinate objects in the object.

Each of the following objects contains a DataSources collection:

  • clsCube

  • clsDatabase

  • clsMiningModel

  • clsPartition

Each subordinate object (that is, a cube, a partition, or a shared dimension) can have a unique data source. For example, although a cube can contain only one data source in its DataSources collection, each partition or shared dimension within the cube can have a unique data source.

Regardless of the object in which it resides, each DataSources collection contains objects of ClassType clsDataSource.

The DataSources collection contains the name, connection string, and other information used to attach to a data provider.


  An object of ClassType clsDatabase may have more than one data source contained in the DataSources collection, while an object of ClassType clsCube can contain only one data source in its DataSources collection. Objects of ClassType clsMiningModel and SubClassType sbclsRegular will have an OLE DB provider as a data source. For objects of ClassType clsMiningModel and SubClassType sbclsOlap, the data source is assumed to be the same as for the object where the mining model is stored.

Community Additions