DTS Programming
Collections
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. |