Re: Problem Directing BCP error to error file

On Jan 16, 2008 3:19 AM, Rajpreet <rajpreetsidhu@xxxxxxxxx> wrote:

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.

Is this question about Perl? I think you sent it to the wrong list.
There may be a forum elsewhere about this bcp program, or related
things. Good luck with it!

--Tom Phoenix
Stonehenge Perl Training
.

Relevant Pages

  • Problem Directing BCP error to error file
    ... 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 ... Query ...
    (perl.beginners)
  • Error Directing BCP In Errors to error file
    ... 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 ... Query ...
    (comp.unix.questions)
  • Error directing BCP In errors to error file
    ... 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 ... Query ...
    (comp.unix.shell)
  • Problem directing BCP Error to Error file
    ... 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 ... Query ...
    (comp.lang.perl.misc)
  • 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)