For Programmers: Free Programming Magazines  


Home > Archive > PERL Beginners > January 2008 > Problem Directing BCP error to error file









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Problem Directing BCP error to error file
Rajpreet

2008-01-16, 8:01 am

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?

TIA.

Regards,
Rajpreet

Tom Phoenix

2008-01-16, 7:02 pm

On Jan 16, 2008 3:19 AM, Rajpreet <rajpreetsidhu@gmail.com> 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
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com