Re: Bcp in problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Arzan (Arzan_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 10:14:05 -0700

Yes i use the -e option however the error file is empty. It runs without error however terminates after 2 million records. Any suggestions

Thanks.

"TJTODD" wrote:

> There must be some problem that is specific to your environment. have you
> tried using the -e (for error file) and -o (for output file)?
>
> Most likely some details should be written to one of these files that would
> help you diagnose the problem.
>
> --TJTODD
>
> "Arzan" <Arzan@discussions.microsoft.com> wrote in message
> news:A131C4C7-4BEC-4548-B51A-E02EF01E0540@microsoft.com...
> > Hi,
> >
> > I am loading a table with 7 million records using bcp in, however, what i
> noticed it that the bcp in process terminates when it reaches around 2.5
> million rows.
> >
> > I don't feel there should be any such limitation on bcp, however would
> like to know if anyone have come across this problem and how they have
> worked around to resolve this problem.
> >
> > Thanks.
>
>
>

Relevant Pages

  • Re: bcp has primary key contraint error
    ... Specifies the full path of an error file used to store any rows bcp is ... PRIMARY KEY constraint 'table_name'. ...
    (microsoft.public.sqlserver.server)
  • Re: Problem directing BCP Error to Error file
    ... Though the bcp in works fine but the error file is not being created ... Why are you asking questions about bcp in a Perl newsgroup? ... helped with your Perl problems a week ago, but it seems the problem you ...
    (comp.lang.perl.misc)
  • Re: Almost there with bulk insert
    ... SET ANSI_WARNINGS OFF before you do the bulk insert. ... Yes, you can specify an error file with BULK INSERT too, ... but BULK INSERT and BCP behaves differently in this case. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Problem Directing BCP error to error file
    ... Though the bcp in works fine but the error file is not being created ... Query ... Stonehenge Perl Training ...
    (perl.beginners)