Dear all,
I am balamurugan,new for ssis.we have sql server source & destination is oracle.we need to implement the following steps in ssis:
1. SQL to ORACLE record insert ===> its completed.
2.SQL to ORACLE --->we need to check forign key of table based record in primary key table if record available the foreign key table record move to oracle table.if record is not in primary key table we give retry job until records(retry time is 5 ) received in PK table.(referencial integrity constriant check).
3. how to load balance the records for insert.
EX: in source we have 1lak records we need to insert the 1000(set limit 1000 ) records vise versa..
please help on this????????????