Hi guys

I have a small problem. I want to use BCP with in a transaction it's this

first I execute a SQL Statement against the database and delete some data,
then
I run the BCP utility.

my problem is how to use these two with in a single transaction!

please help me

I appreciate your help and time!
thanks,
-Aruna

You cannot. Try using DTS, after this is a DTS newsgroup. You can setup a
package level transaction that spans the Exec SQL Task to run your script
and the Data Pump task or Bulk Insert task data transfer.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Aruna Tennakoon" <aruna.tennakoon (AT) gmail (DOT) com> wrote