Export (0) Print
Expand All

DynamicPropertiesTask Object

SQL Server 2000

The DynamicPropertiesTask object changes the values of package objects properties at runtime. Any property of any object in the package can be modified. This is useful for packages created with Data Transformation Services (DTS) Designer and the DTS Import/Export Wizard because many package object properties are fixed after the design process is complete.

The Dynamic Properties Task object provides several different sources for the new value of a property:

  • A constant

  • The contents of a data file

  • An environment variable

  • A DTS global variable

  • A field in an .ini file

  • An SQL query

In an application that creates and manipulates DTS objects, it is often easier to modify the values of properties directly in code rather than use a Dynamic Properties Task object. However, if part of a DTS package is contained within a module that cannot be modified easily, the Dynamic Properties Task object may be useful.

DynamicPropertiesTaskAssignments Collection Properties Collection

© 2015 Microsoft