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

In article
<b24d11cb-5c7d-4532-9809-ab737876e1bc [at] f10g2000hsf.googlegroups.com>,
Rajpreet <rajpreetsidhu [at] gmail.com> 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

On Jan 16, 10:54=A0pm, Jim Gibson <jimsgib... [at] gmail.com> wrote:
> In article
> <b24d11cb-5c7d-4532-9809-ab737876e... [at] f10g2000hsf.googlegroups.com>,
>
> Rajpreet <rajpreetsi... [at] gmail.com> 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 =A0the 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 =A0-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
>
> =A0Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> =A0 =A0 ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ---------------------------------------------------------- =A0 =A0 =A0 =A0=

> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0http://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