sybperl-l Archive

From: "Shanbhag, Mitesh (London)" <ShanbMit at exchange dot uk dot ml dot com>
Subject: RE: How to use BCP and Perl
Date: Sep 19 2002 11:13AM

all that info goes to your stdout so do this -

system 'bcp ccr_dev..personofferhistoryload in
g:\agisdev\docs\currdev\11425\bcp_infile.txt -c -e bcpload_fail.txt -h
"ORDER (personid ASC)" -Uusername -Ppasswd -Sservername' 1>  2>
;

any output from bcp should now be 

-----Original Message-----
From: Mark Sutfin [mailto:MSutfin@affinitygroup.com]
Sent: Tuesday, September 17, 2002 8:53 PM
To: SybPerl Discussion List
Subject: How to use BCP and Perl


To BCP data into an SQL Server db table, I have been using this code
snippet:
system 'bcp ccr_dev..personofferhistoryload in
g:\agisdev\docs\currdev\11425\bcp_infile.txt -c -e bcpload_fail.txt -h
"ORDER (personid ASC)" -Uusername -Ppasswd -Sservername';
I would like to capture some of BCP's messages, (e.g. starting to copy, rows
sent to server, packet size).
I realize this is not a list for SQL Server, but any direction would be much
appreciated.
SQL Server 2000

Mark Sutfin