Data Management Object Model Reference

IDataSource Members

IDataSource overview

Public Instance Properties

CDSCSourcereturn an interface pointer to the connection CDSC source
ConnectionStringThe ConnectionString.
DataBaseName of the Database to access.
DataSourceComponentThe data source component. Example "mrRdbDsc".
DescriptionThe DataSource Description.
InitialCatalogThe location of metadata. Optional. Example : "C:\Temp\5816YN.MDD".
InitialProjectThe name of the project.
IsOpen Tells whether the datasource has been opened.
JoinKey The join key for merge
JoinKeySorted Specifies whether the joinkey is already sorted, so that the ORDER BY clause will not be used in the select query.
JoinType The join type for merge
LocationLocation of data source if file based. Example : "C:\Temp\5816YN.SAV".
MDMDocumentReturns an interface pointer to the underlying MDM document object. Property is Read-Only.
MetaDataOutputNameOutput name of transformed metadata (especially when transforming to multiple outputs)
ModeThe mode to open the data source in. Example : DataSourceOpenMode.ReadWrite.
MRInitAllowDirty Contains the initialization information for aloowing dirty data
MRInitCategoryNames Contains the initialization information for using Category Names
MRInitCategoryValues Contains the initialization information for using Category Values
MRInitCustom Contains the initialization information for the custom property
MRInitInputLocale Contains the initialization information for the input locale
MRInitMDMAccess Contains the metadata access intialization information
MRInitMDMContextContains the metadata context intialization information(e.g. what context to use when loading from MDM)
MRInitMDMDocumentContains the metadata labeltype intialization information(e.g. what labeltype to use when loading from MDM)
MRInitMDMLabelTypeContains the metadata labeltype intialization information(e.g. what labeltype to use when loading from MDM)
MRInitMDMLanguageContains the metadata language intialization information(e.g. what language to use when loading from MDM)
MRInitMDMVersionContains the metadata version intialization information(e.g. what version to use when loading from MDM)
MRInitMDSCContains the metadata DSC intialization information
MRInitOutputLocale Contains the initialization information for the output locale
MRInitProject Contains the initialization information for the project
MRInitValidation Contains the initialization information for validation
NameThe DataSource Name.
OLEDBProviderThe OLEDB provider. You typically set this to "mrOleDB.Provider.2".
OriginalConnectionStringThe original ConnectionString.
PasswordPassword of user. This will be used to connect to a database data souce.
ProviderSubTypeGet/Set Transformation provider sub type
QueryStringContains the SQL statement for the Rowsets
TableOutputNameNew table name (used only with NON MROLEDB Exports)
TransformationContent Sets/gets the metadata contents of the transformation Also detect the provider type and provider sub type used. Possible values are enumerated in TransformationContent
TransformationProviderGet/Set Transformation provider type
TransformationStopped indicates wether transformation is stopped because of writet errors
TransformationType Get/Set the transformation type. Either ADD or UPDATE
UpdateQueryStringA direct SQL string for UPDATES,INSERT and DELETE
UseInputAsOutputIf this is non null the input dataset is used for output
UserIDUser ID of user. This will be used to connect to a database data souce.
VariableOutputOrder Specifies the output order of the variables.

Public Instance Methods

Close Close the connection
CreateRowsetOverloaded. Create a recordset. This creates an ADO rowset
ExecuteWithNoRowset Create the schema either by "exec xp_syncdb" or by "CREATE TABLE VDATA......" or using the update querystring
Open Open the connection
SetConnectionStringOverloaded. Sets the connection string

See Also

IDataSource Interface | SPSSMR.Data Namespace