June 14, 2004 at 3:51 pm
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
June 14, 2004 at 3:56 pm
load from file: EM, right click DTS, select "open"
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 14, 2004 at 4:01 pm
That did it. Thank you so much.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply