Re: Log Shipping & dts packages

#1

Would you really need real time ?
You cannot place triggers on system tables.
You could use DTS to export the table sysdtspackages to text file every 1/2
hour ? and then have a package on the other side suck it in.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Tony Loparco" <tloparco (AT) envestnetpmc (DOT) com> wrote

Quote:

We have log shipping setup to keep several databases in
synch on primary and secondary SQL2000 servers. Does
anyone know of a way to do the same with the dts
packages. Currently we have to maintain the dts packages
manually on both servers, which is time-consuming and
error-prone. We'd like to be able to automate this so
that when a dts package is created or modified on primary,
it automatically get copied to secondary and is runnable
on secondary without making any changes to connections,
etc. Any suggestions?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Log Shipping & dts packages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Log Shipping & dts packages - 08-12-2003 , 01:13 AM