Re: SQL Server advice

2002-09-23 Thread Douglas Jordon
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

Re: SQL Server advice

2002-09-21 Thread I-Lin Kuo
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

Re: SQL Server advice

2002-09-20 Thread Douglas Jordon
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

RE: SQL Server advice

2002-09-19 Thread Bryan F. Hogan
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

Re: SQL Server advice

2002-09-19 Thread Richard Meredith-Hardy
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

RE: SQL Server advice

2002-09-19 Thread Tipton Josh (orl1jdt)
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

Re: SQL Server advice

2002-09-19 Thread Douglas Jordon
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