Export (0) Print
Expand All

Collections

SQL Server 2000

This section describes the collections of the Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) object model. Collections contain groups of related DTS objects.

Topic Description
Columns Collection Contains descriptions of meta data for columns in a data source.
Connections Collection Contains information about connections to OLE DB service providers.
DTSMQMessages Collection Defines the messages to be sent by a DTSMessageQueueTask object.
DynamicPropertiesTaskAssignments Collection Defines the properties to be changed by a DynamicPropertiesTask object.
GlobalVariables Collection Contains information about data to be shared across DTS steps.
Lookups Collection Defines query strings that allow data retrieval from other than the row being transformed.
OLEDBProperties Collection Contains properties for an OLE DB service provider.
OLEDBProviderInfos Collection Provides information about available OLE DB service providers.
PackageInfos Collection Provides information about packages stored in SQL Server 2000 Meta Data Services or SQL Server storage.
PackageLineages Collection Provides the contents of package lineage records from Meta Data Services.
PackageLogRecords Collection Provides the contents of package log records from an instance of SQL Server.
PrecedenceConstraints Collection Contains conditions that must occur before a step can execute.
Properties Collection Contains a collection of properties for an object.
SavedPackageInfos Collection Contains information about packages saved in files.
ScriptingLanguageInfos Collection Provides information about Microsoft ActiveX® scripting languages available on the system.
StepLineages Collection Provides the contents of step lineage records from Meta Data Services.
StepLogRecords Collection Provides the contents of step log records from an instance of SQL Server.
Steps Collection Contains information about the flow and execution of DTS tasks.
TaskInfos Collection Provides information about the tasks available on the system.
TaskLogRecords Collection Provides the contents of task log records from an instance of SQL Server.
Tasks Collection Contains information about the tasks in a DTS package.
TransformationInfos Collection Provides information about the DTS transformations available on the system.
Transformations Collection Defines the transformations used by a task.
TransformationSets Collection Defines the sets of transformations used to process components of a hierarchical rowset.

Show:
© 2014 Microsoft