Re: DTS Commit question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
Date: Sat, 15 Jul 2006 09:52:53 +0000 (UTC)

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

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.

Prev by Date: Re: How do I use a variable in the TO feild of the SSIS Send Mail Task
Next by Date: Re: SSIS Column Mapping Problem
Previous by thread: Re: How do I use a variable in the TO feild of the SSIS Send Mail Task
Next by thread: Re: Dynamically change For Each Loop
Index(es):
- Date
- Thread

Relevant Pages

Re: MSDAORA was unable to begin a distributed transaction - why?
... settings described for Oracle Client 8.1 in article ... 'OraOLEDB.Oracle' was unable to begin a distributed transaction. ... The linked server is set up with RPC and RPC OUT toggled on and as far as I ... can tell all the registry entries are in place (although they use Oracle 8.1 ...
(microsoft.public.sqlserver.security)
Re: Managing 300+ ios per second
... > wont help while we stay on a queue_depth of 8, ... By increasing maxreqs we could, perhaps, cache only ... there are quite some information about settings available. ... combination with Oracle and DB2 UDB database systems. ...
(comp.unix.aix)
Re: Managing 300+ ios per second
... > wont help while we stay on a queue_depth of 8, ... By increasing maxreqs we could, perhaps, cache only ... there are quite some information about settings available. ... combination with Oracle and DB2 UDB database systems. ...
(comp.unix.aix)
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
... tried different settings for NLS_LANG ... Subject: Perl 5.8.9 DBI/DBD::Oracle make test error ... I am using tnsnames.ora file in my Oracle Instantclient folder. ... When I connect using SQLPlus, I am using the command below: ...
(perl.dbi.users)
Re: Is Interbase still thriving?
... short of reengineering the whole SQL and database structure around ... But, considering, as I said, that DB2, Sybase ASE and MS SQL shares ... this approach to transaction consistency, do you really think it could ... Oracle DB. ...
(borland.public.delphi.non-technical)