Application Object

DTS Programming

DTS Programming

Application Object

The Application object provides access to system properties and information about system components. It returns connections to Microsoft® SQL Server™ storage or to SQL Server 2000 Meta Data Services instances that contain Data Transformation Services (DTS) packages.

Collections
OLEDBProviderInfos Collection TaskInfos Collection
Properties Collection TransformationInfos Collection
ScriptingLanguageInfos Collection  
Properties
DesignerSettings Property Parent Property
JITDebug Property  

Methods
GetPackageRepository Method GetPackageSQLServer Method

Remarks

The Application object is not derived from another DTS component. Instead, it is created. For example, do this with the New operator in Microsoft Visual Basic®:

    Dim objDTSAppl      As DTS.Application
    . . .    
    Set objDTSAppl = New DTS.Application

The system properties accessible through the Application object are:

  • Whether Phased Transformation features are visible in DTS Designer.

  • Whether script run-time errors cause the scripting debugger to be entered.

The system components about which information is accessible through the Application object are:

  • The set of OLE DB providers available on the system.

  • The scripting languages that can be used in ActiveX® Script tasks, ActiveX Script transformations, and step scripts.

  • The DTS tasks available on the system, including the tasks provided with SQL Server 2000 and custom tasks implemented by users and other vendors.

  • The DTS transformations available on the system, including the transformations provided with SQL Server 2000 and custom transformations implemented by users and other vendors.
Examples

For more information about the Application object and examples of its use, see Retrieving DTS System, Package and Log Data.