|
|
Posted by Roy Harvey on 07/05/07 21:28
On Thu, 05 Jul 2007 17:34:42 -0000, Emin <emin.shopper@gmail.com>
wrote:
>Dear Experts,
>
>What is the best way to do a large insert WITHOUT having direct access
>to the machine SQL Server is running on? For example, imagine I want
>to insert something like 20,000 records. If I were to have access to
>the server, I could BULK INSERT into a temp table and then insert into
>the destination table. But if I can't create a file on the server to
>use for BULK INSERT, what is the next best alternative to doing lots
>of 1 record insert statements?
>
>Thanks,
>-Emin
The Bulk Copy command line utility BCP.EXE is one alternative, as are
DTS (SQL Server 2000) and SSIS (2005) executing locally.
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|