Choosing a Development Platform

You can use any automation controller as a development platform to program DTS packages and objects (Microsoft® Visual Basic®, Microsoft Visual C++®, Microsoft Visual J++™, and so on). If you use a third-party automation controller, see the third-party documentation for information about how to program objects for the particular platform.

When adding an object to a collection, you should follow these steps:

1. Define the collection.
2. Define the object and assign values to optional and required properties.
3. Add the object to the collection.

The required object properties are:

• Transformation.Name
• Connection.ID
• Task.Name
• Step.Name
• Step.TaskName
• PrecedenceConstraint.PrecedenceBasis
• PrecedenceConstraint.Value

For more information about object programming, see your Microsoft programming platform documentation.

You can use the following development platforms to create a DTS application:

• Visual C++ development system
• Visual Basic programming system
• Visual Basic for Applications
• Java

See Also

DTS Samples