Log shipping and DTS packages update

Hello,
I just implemented log shipping on SQL Server 2000 Developer edition
and I need to keep all modifications to DTS packages on Primery Server
to be replicated on Standby Server. Could you please give me a hint how
to do that?
Thanks,
GBGB wrote:

> DTS packages
From microsoft:
"Copying DTS Packages
DTS packages can be stored in the msdb database or in the file system.
If you have DTS packages that run on the primary server on which your
production database relies, you must manually copy these DTS packages
to each standby server. You cannot simply back up the msdb database and
restore it to a standby server. Doing so overwrites all jobs, alerts,
operators, and DTS packages in the msdb database on the standby server.
You can open DTS packages saved to the msdb database on the primary
server and save them to each standby server. Simply copy DTS packages
saved to the file system on the primary server to a folder on each
standby server. Complete this task before users connect to a standby
server that is promoted to become the new primary server.
Use the following procedure to copy DTS packages that the production
database needs to each standby server.
To copy DTS packages
1.
For each DTS package stored in the file system on the primary server,
copy the DTS package to each standby server using Windows Explorer.
When copying DTS packages to each standby server, use the same drive
and path that the primary server uses. Doing so eliminates potential
path problems.
2.
For each DTS package stored in the msdb database on the primary server,
use SQL Server Enterprise Manager to open the DTS package, and then
save it to the msdb database on each standby server.
Note: To ensure DTS packages execute properly on a subscriber, use an
alias or the dynamic properties task. For more information, see
"Redirecting Client Network Traffic to a Promoted Secondary Server" in
Planning Guide Chapter 5, "Minimizing Downtime by Using Redundant
Components.""
This article might be handy:
http://www.dbazine.com/sql/sql-articles/larsen8
HTH,
Stijn Verrept.