How to set a bigger rollback segment?

Hi,

I′m trying to transfer a large amount of data from Oracle 8 to Sql Server. For each table, I have an OleDBSource with DataAccessMode Command (select with one inner join), Data Conversion and OleDBDestination. Sometimes I′m getting an ORA-01555 snapshot too old error, so I′d like to set a bigger rollback segment, but don′t know how. Please, can anybody help me?

Thanks

Janca

That has nothing to do with SSIS. That is an Oracle DB related issue that needs to be address for the DBA.

Whatever you are doing in the package; Have you tried to commit the SSIS work in a smaller batches? That is something you can controll.