Hi All,

I've just transfered all the DTS packages i have on an old SQL 2000 server
to a new SQL 2000 box, and they appear to have lost all the structure and
notes that had been placed in them.

Is this correct, and is there a way to prevent it occuring, as these notes
form a valuable part of understanding the processes that are going on.

I used DTSBackup2000 to do this, in case it helps.

TIA,

Jason

"Jason Lees" wrote:

Jason,

DTSBackup2000 has two methods for transferring packages. The default uses
the object model and doesn't guarantee that your package will look the same
grapically after the transfer. The other method, the direct transfer method
reads the msdb.dtspackages system table on the source server and directly
inserts into the same table on the destination server.

To use the direct method, click on View, Options, and the Transfer tab.
Check the box next to "Use direct transfer method...". Your original pakcage
layout and text annotations will be preserved.


"Jason Lees" wrote: