I-Lin Kuo wrote:
I'm coming in on this late, but you don't have to use
2 operations. As you said a transform will work. But
each transform will fill up only one table. Also, a
package may consist of many operations, each performed
conditionally based on whether other operations
succeeded or
I'm coming in on this late, but you don't have to use
2 operations. As you said a transform will work. But
each transform will fill up only one table. Also, a
package may consist of many operations, each performed
conditionally based on whether other operations
succeeded or failed, so certainly
Thanks for the helpful advice. It looks as though everything can be done
via DTS. The only small drawback is that I have to use two DTS packages
- one to copy most of the tables and another using a query. I don't see
any way that data from mulitple tables can be inserted into multiple
When you created your DTS there is an option to schedule to run, if you can
schedule your dump from the backups at say 1am and then schedule your DTS to
pickup at 1:15am, I don't forsee a problem. You can also save the following
as a stored procedure and create a cf template and add it to the
I do this all the time with WDDX packets. I expect XML is the modern
way. Depending on how well your machines can talk to each other it could
be completely automatic.
Douglas Jordon wrote:
We need to synch a db that drives a web site to the master on our
clients LAN. Because of licensing
or the scheduled job
to do sql or os tasks before and after the job kicks off.
Joshua Tipton
-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:02 PM
To: CF-Talk
Subject: Re: SQL Server advice
I do this all the time with WDDX packets. I
Thanks, that is a help.
Bryan F. Hogan wrote:
When you created your DTS there is an option to schedule to run, if you can
schedule your dump from the backups at say 1am and then schedule your DTS to
pickup at 1:15am, I don't forsee a problem. You can also save the following
as a stored
7 matches
Mail list logo