I have created a DTS package which transform rows of one table from sql
server to oracle.
What happens is while transforming rows, if there is a error occured at 2100
row, It still writes
2099 rows into oracle table..how can i avoid it ? I want to write everything
or nothing ?

Pls let me know.

Have you set the Insert Batch size property on the Options tab for the
transform data task to anything else then 0? I guess you've put 1000 there?
That means that every 1000 records that are correct get written to the target
in 1 batch.

Also deselect "always commit final batch".

Right-click transform data task -> workflow properties -> options -> select
all three boxes in the Transaction section.

Right click anywhere in the package -> package properties -> advanced ->
select both boxes in the Transaction section.

Hi Frans,
I have exact setting in the DTS package except the first check box for the
following.
Right-click transform data task -> workflow properties -> options -> select
all three boxes in the Transaction section.

It gives me run time error if i select
Join Transaction if present
because i have oracle db is in destination connection. i have selected
Microsoft ODBC driver for Oracle in the data source for oracle..
i had also selected Microsoft OLE DB provider for Oracle and which gives me
error too.

Pls let me know.

"Frans van Bree" wrote:

Hmm, looks like the Microsoft Transaction Services (MTS) need to be activated
on the Oracle database.

More here:
http://www.oracle.com/technology/tec...mts_815_wp.htm

Without it I don't think it will work...

We have oracle db on UNIX platform. I have to find something similar...

thanks

"Frans van Bree" wrote: