Is there a way to BCP a sectional bulk of data (like using
process date) fr tbl1 (in db1) and copy/append into tbl2
(in db2) within the same server?

I am trying to increase speed of my copy process here so
that I don't have to copy one record at a time. Any
suggestions will be very much appreciated.

In message <84ae01c43205$54f627e0$a301280a (AT) phx (DOT) gbl>, Steven Wong
<anonymous (AT) discussions (DOT) microsoft.com> writes
BCP is for importing or exporting data via text files only, so no and it
certainly does not have the copy or append functionality.

Using DTS you can use the either the DataPump task or Data Driven Query
Task to transfer data between SQL, but if this all in the same server
why not use SQL? This doesn't have to be row by row, as you can run
multiple statements for insert vs update, but to provide full insert or
update checks DTS will be.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Allan:

First of, thanks for your response.

Yes, the 2 dbase are in the same server. However, when I
use SQL statement (Select/Insert) in the "Execute SQL
Task" of the DTS to copy the data I needed, it will be
copying one record at a time, right?

If I understand correctly, you are saying that in DTS, you
can copy "chunks of data" at a time? How would you do
that? Please provide some guidance.

No:

It will insert in batches using the DataPump task. By Default this is set
to insert "All Or Nothing". You can set it up for each row being a seperate
batch if you really want.

The ExecuteSQL task is nothing more than QA in DTS. You can use it to
execute your statements against SQL Server just like you would in QA.

--
--

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


"Steven Wong" <anonymous (AT) discussions (DOT) microsoft.com> wrote