|
|
Posted by Alex Kuznetsov on 07/06/07 13:29
On Jul 5, 12:34 pm, Emin <emin.shop...@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
You can put your file in a shared folder - BULK INSERT can read it if
it is accessible by the account SQL Server runs under.
Alex Kuznetsov, SQL Server MVP
http://sqlserver-tips.blogspot.com/
Navigation:
[Reply to this message]
|