Our msdb.sysdtspackages table became corrupt. I wanted to restore a previously backed up version of the table until I discovered to my chagrin that we were not backing up the msdb tables.
The good news is that there is the Mssql7\Install\Instmsdb.sql script that will re-create any msdb tables that are deleted. The other piece of good news is that a recent tinkerer did a Save As to files of all DTS's.
I didn't see anything in the documentation about how to load a DTS from a file. Could someone walk me through this?
Incidentally, there are some packages saved as local, and some as repository. What is the difference and which is preferred?
TIA
Andre