Hi, Anyone.

I am using SQL Server 2005 SSIS(SQL Server Integration Service).

The source DB is Oracle 9i.
There are several rollback segments in Oracle, but these rollback segments are small except one.

So, I want to use the largest rollback segment when data exporting.

How can I set the largest rollback segment in SSIS workflow?

Hi Samuel,

Within oracle envirement you can set rollback segment for a transaction by

SET TRANSACTION USE ROLLBACK SEGEMENT rbig;

where "rbig" will be the larget rollback segment name

Hope it helps you ...

Thx