DataSources Collection

Analysis Services Programming

Analysis Services Programming

DataSources Collection

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.

Remarks

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

Note  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.

See Also

clsCube

clsDatabase

clsMiningModel

Collections

Collection Methods

Collection Properties