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
We need to synch a db that drives a web site to the master on our
clients LAN. Because of licensing concerns, the two DB can't talk
directly to each other, and it has been decided that an intermediary is
called for. So I need to:
1. Copy a few tables and query another(for all columns except
:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:48 AM
To: CF-Talk
Subject: SQL Server advice
We need to synch a db that drives a web site to the master on our
clients LAN. Because of licensing concerns, the two DB can't talk
directly to each other, and it has been decided
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
Bryan
-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:48 AM
To: CF-Talk
Subject: SQL Server advice
We need to synch a db that drives a web site to the master on our
clients LAN. Because of licensing concerns, the two DB
I have a query that works well with postgreSQL
I just uploaded the code to a SQL Server installation and this query is failing with
the Error:
---
Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near 'LIMIT'.
SQL = SELECT *
FROM SPCData, Device
WHERE
17, 2002 11:29 PM
Subject: Need quick SQL Server Advice
I have a query that works well with postgreSQL
I just uploaded the code to a SQL Server installation and this query is
failing with the Error:
---
Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near
SELECT TOP 8 *
FROM SPCData, Device
WHERE SPCData.SPCDitem_ID = 1
AND SPCData.SPC_Device_ID = Device.Device_ID
ORDER BY SPCData_ID DESC
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.375 / Virus Database: 210 - Release
Paul, Doug Thanks!
At midnight things get blurry
At 11:48 PM 7/17/02, you wrote:
SELECT TOP 8 *
FROM SPCData, Device
WHERE SPCData.SPCDitem_ID = 1
AND SPCData.SPC_Device_ID = Device.Device_ID
ORDER BY SPCData_ID DESC
---
Outgoing mail is certified Virus Free.
Checked by AVG
12 matches
Mail list logo