Re: Problem directing BCP Error to Error file

On Jan 16, 10:54 pm, Jim Gibson <jimsgib...@xxxxxxxxx> wrote:
In article
<b24d11cb-5c7d-4532-9809-ab737876e...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,

Rajpreet <rajpreetsi...@xxxxxxxxx> wrote:
Greetings,

I am trying to bcp in data to a table which is in different server.
Though the bcp in works fine but the error file is not being created
and rejected records are not being directyd to  the error file. Query
looks like:

bcp <db>..test_b_plan_cp in /home/file_out.txt -c -t '|' -S *****-U
****** -P ******-I /home/bcp2db_sql.ini  -e /home/bcp2db.error.

Can someone please help?

Why are you asking questions about bcp in a Perl newsgroup? You were
helped with your Perl problems a week ago, but it seems the problem you
are having now is strictly with bcp.

--
Jim Gibson

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
               http://www.usenet.com

Sorry for the inconvenience caused. Actually the reason I posted it
here because I was trying to do bcp from within a perl script and
there in I was facing issues.

Is there any alternative to it? And can we use Sybase::BCP module
using an ini file?

TIA
.

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: 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)
  • Re: Bcp in problem
    ... Yes i use the -e option however the error file is empty. ... It runs without error however terminates after 2 million records. ... "TJTODD" wrote: ... > noticed it that the bcp in process terminates when it reaches around 2.5 ...
    (microsoft.public.sqlserver.server)
  • Re: BCP Utility
    ... pre-processor in Perl or so which adds the missing columns, before BCP will ...
    (microsoft.public.sqlserver.programming)