DTS objects and properties

Some information on DTS objects and properties and where to find more.


DTS objects and properties
Barrie Sosinsky

When using the Data Transformation Services (DTS) you often need to figure out which object and property is required. You will find the DTS model hierarchy described in the SQL Server 2000 Books Online. That resource also contains explanations of each object collection, property and method. This information will aid you in selecting the correct object as well as give you information on how to obtain that object.

You can also use the Script Debugger to put an ActiveXScript task into the debug mode. The debugger will show you local windows that should help you determine how each object's properties are used. You may also want to open the Object browser in DTS to view its information.

Barrie Sosinsky (barries@killerapps.com) is president of consulting company Sosinsky and Associates (Medfield MA). He has written extensively on a variety of computer topics. His company specializes in custom software (database and Web related), training and technical documentation.

This was first published in March 2002

Dig Deeper on Microsoft Windows 2000 Server Administration



Find more PRO+ content and other member only offers, here.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:









  • VDI assessment guide

    Wait! Don't implement VDI technology until you know your goals and needs. A VDI assessment should consider the benefits of a VDI ...

  • Guide to calculating ROI from VDI

    Calculating ROI from VDI requires a solid VDI cost analysis. Consider ROI calculation models, storage costs and more to determine...

  • Keep the cost of VDI storage under control

    Layering, persona management tools and flash arrays help keep virtual desktop users happy and VDI storage costs down.