Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This document covers versioning issues in the following areas:
The file format that is described in this document applies to the versions of DTS that are produced by Microsoft SQL Server 2000 and Microsoft SQL Server 2005. DTS is deprecated in Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2 and is replaced by Microsoft SQL Server Integration Services (SSIS); however, DTS packages can still be managed and run in SQL Server 2008 and SQL Server 2008 R2. For more information, see [MSDN-DTS] and [MSDN-DTSS2008R2].
The version substorage was originally implemented as a simple substorage of the containing compound file, as documented in section 2.2.1. Starting with Microsoft SQL Server 7.0 Service Pack 2, the version substorage was implemented by using an in-memory technique and persisted as a copy of that memory in a substream of the containing compound file, which is named by using the convention that is specified in section 2.2.1.
Some package variables were added over time. As DTS packages are updated according to the respective versions of Microsoft SQL Server for which they were written or updated, the presence or absence of the properties of these DTS packages is required to be taken into account based on the values that are in the version directory entry in the respective version of SQL Server.