ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mario Madunic <haj...@imag.net>
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" />
</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


Mime
View raw message