To run this you will require Microsoft Visual Basic 5 Runtimes , Microsoft ActiveX Data Objects 2.1 Library and the Microsoft DTS Package Object Library installed on the local machine. The latter two come with SQL Server and the VB 5 Runtimes can be downloaded from the Microsoft site. Please note that DTSBackup does not support owner or operator passwords in DTS packages. The main reason for this is that when backup or restoring a DTS Package, I load the package. To do this requires a password for encrypted packages.
All suggestions welcome.
COM-structured storage files can hold multiple versions of a package. When performing a backup, if the file already exists, the current backup will be appended to that file. When restoring, the most recent version will be restored. To access previous versions, use Enterprise Manager to open the file. Multiple packages can be saved to the same COM file, however this is not recommended with DTSBackup.