sybperl-l Archive
Up Prev Next
From: Mark Sutfin <MSutfin at affinitygroup dot com>
Subject: How to use BCP and Perl
Date: Sep 17 2002 7:53PM
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
|
