Application.UpdateObjects Property

Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Public Property UpdateObjects As Boolean
/** @property */
public boolean get_UpdateObjects ()

/** @property */
public void set_UpdateObjects (boolean value)

public function get UpdateObjects () : boolean

public function set UpdateObjects (value : boolean)

Property Value

true if extensible objects can be updated at package load time when an updated version is found; otherwise, false.

When new versions of extensible objects such as the tasks, Foreach enumerators, log providers, and connection managers become available, existing packages can be updated at load time to reference the new objects. You can do this by setting the UpdateObjects to true before loading the package.

Each extensible object implements a CanUpdate property. The runtime tries to load the existing package, and if it finds a reference to an older object, the package tries to update its references. It first enumerates all the extensible objects it contains, excluding the Pipeline, which is treated separately and locally, and for each object, calls CanUpdate on the new object passing the ID of the old one. If the new object can update the old object, the old object is passed to the new one through the Update method, and the XML is changed in place. By default, all extensible objects implement CanUpdate to return false, in which case Update does nothing to the XML that is passed.

The following code example shows how to toggle the UpdateObjects property to enable or prevent updates. It sets the UpdateObjects to true, prints the value of the property, sets it to false, and prints out the value again.

Class ApplicationTests
        Shared  Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim updateObjs As Boolean =  True 
            app.UpdateObjects = updateObjs
            updateObjs = False
            app.UpdateObjects = updateObjs
        End Sub
End Class

Sample Output:



Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions