DTS Commit question

#1

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.

#2

Hello mvp,

Can you wrap this in a Transaction?

What are the settings you are using on the Transform Data Task?

Are there any settings on the Oracle side (driver etc) that would cause this~?

Allan

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Commit question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Commit question - 07-13-2006 , 10:46 AM

Re: DTS Commit question - 07-15-2006 , 04:52 AM