ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mario Madunic <>
Subject Re: BCP and ANT
Date Fri, 03 Aug 2007 12:46:53 GMT
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" />

Marijan (Mario) Madunic

Quoting Bevan Arps <>:

> 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:
For additional commands, e-mail:

View raw message