I use SQL 2000 and I'm trying to write a DTS package to transfer the
sysdtspackages table from msdb. For some reason when I select msdb
from the list as the source, a lot of the sys tables (including
sysdtspackages) don't show up as a selection. Whats the deal here?
They don't show up as a destination either when I select msdb as my
destination database.
I know other ways to transfer DTS packages so that's not what I need,
I'm just interested in this particular solution.