You should build a DTS package that runs on a schedule every night. It
will be easy to run those checks and make your inserts... with a DTS
package.
--Ferg
Michael Grove wrote:
I need to insert multiple rows into a SQL database from an Access Database.
Basically I have an ecommerce site with
This is the process we use here at work. We use DTS to query some views on
the oracle server then do some checks within our DTS package and insert the
data into the MSSQL server. I think it might run a SP on the MSSQL side as
well, but am not 100% certain since been many months since I had to get
Hi Michael,
I'd probably avoid using ColdFusion altogether to import the data.
Instead, look into creating a DTS package through the MS SQL
enterprise manager; DTS exists exactly for this type of situation.
-Joe
On 11/18/05, Michael Grove [EMAIL PROTECTED] wrote:
I need to insert multiple
Simple SQL Script will do it, or a DTS if you want overkill.
;-p
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: 21 November 2005 13:42
To: CF-Talk
Subject: Re: Multiple Row Insert Into SQL from another database
You should build a DTS package that runs
November 2005 13:42
To: CF-Talk
Subject: Re: Multiple Row Insert Into SQL from another database
You should build a DTS package that runs on a schedule every night. It
will be easy to run those checks and make your inserts... with a DTS
package.
--Ferg
To: CF-Talk
Subject: Re: Multiple Row Insert Into SQL from another database
It's hardly overkill to use something for it designed purpose. It's
simply the right tool for the job.
--Ferg
Robertson-Ravo, Neil (RX) wrote:
Simple SQL Script will do it, or a DTS if you want overkill.
;-p
I am curious what would the SQL script look like to connect to the MS Access
and then insert into the current MSSQL db? I do not work with MSSQL enough
to know so just curious how simple it is.
On 11/21/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
wrote:
Simple SQL Script will do it, or a
Well, you would obviously need an ODBC connection - you could of course,
script the DTS as well that will show you.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: 21 November 2005 16:04
To: CF-Talk
Subject: Re: Multiple Row Insert Into SQL from another database
I
Yeah, but then I would actually have to install a MSSQL client on this
machine. It would be so much easier to just let someone else do all the work
and show me how easy it is while I am being lazy on this fine Monday.
On 11/21/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
wrote:
Well, you
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Monday, November 21, 2005 11:04 AM
To: CF-Talk
Subject: Re: Multiple Row Insert Into SQL from another database
I am curious what would the SQL script look like to connect
to the MS Access
and then insert
: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Monday, November 21, 2005 11:04 AM
To: CF-Talk
Subject: Re: Multiple Row Insert Into SQL from another database
I am curious what would the SQL script look like to connect
to the MS Access
and then insert into the current MSSQL db? I do not work
800 or even 2400 SQL inserts won't be a big deal, load-wise. I've
handled that many queries in minutes. Are the two databases on
separate servers?
What I would do is use a stored procedure that first checks for the
existence of the record; if the record exists, don't insert,
otherwise, do.
Check if SQL Server has an INSERT OR IGNORE or an INSERT ... ON
DUPLICATE KEY UPDATE statement. If present, the former will insert
all the rows except those that have a primary or unique key conflict.
The latter would do the same thing, except it allows you to specify an
UPDATE statement for
13 matches
Mail list logo