Return-Path: 
 <user-return-61721-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 42645 invoked from network); 3 Aug 2007 12:47:26 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 3 Aug 2007 12:47:26 -0000
Received: (qmail 23137 invoked by uid 500); 3 Aug 2007 12:47:23 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 23106 invoked by uid 500); 3 Aug 2007 12:47:22 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 23095 invoked by uid 99); 3 Aug 2007 12:47:22 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2007 05:47:22 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [216.113.192.14] (HELO mail3.uniserve.ca) (216.113.192.14)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Aug 2007 12:46:57 +0000
Received: from www by mail3.uniserve.ca with local (Exim 3.35 #1)
	id 1IGwYP-000Lrv-00
	for user@ant.apache.org; Fri, 03 Aug 2007 05:46:53 -0700
Received: from 63.76.213.5 ( [63.76.213.5])
	as user hajduk@pop.imag.net by members.uniserve.com with HTTP;
	Fri,  3 Aug 2007 05:46:53 -0700
Message-ID: <1186145213.46b323bd921ff@members.uniserve.com>
Date: Fri,  3 Aug 2007 05:46:53 -0700
From: Mario Madunic <hajduk@imag.net>
To: Ant Users List <user@ant.apache.org>
Subject: Re: BCP and ANT
References: <1185682418.46ac13f2f2e39@members.uniserve.com>
 <46AC166A.6070401@clear.net.nz>
In-Reply-To: <46AC166A.6070401@clear.net.nz>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 3.1
X-Virus-Checked: Checked by ClamAV on apache.org

Thanks Bevan,

Here it is for future reference. Worked like a charm.

<exec executable="bcp">
<arg line="db.table in path\csv.txt -c -S sqlServer -U user -P password" />
</exec>


Marijan (Mario) Madunic

Quoting Bevan Arps <bevan.arps@clear.net.nz>:

> Mario Madunic wrote:
> > has anybody used BCP (bulk copy program) with ANT. I need to insert data
> into a
> > SQL Server and would like to do this within ANT.
> >
> > Any hints on how to do this will be appreciated.
> The most straightforward approach is to first work out how to drive BCP 
> from the commandline (without Ant involved at all) - and then wrap that 
> commandline in an Ant <exec> task.
> 
> Start with a concrete example - fixed paramters, a given input file, and 
> so on, and gradually replace those with parameters one at a time.
> 
> Hope this helps,
> Bevan.
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org