i am new one ssis,we have to implement the following steps in ssis:
source is sql server ,destination is oracle
1) we need to insert the sql to oracle based on some condition.This step can be completed sucessfully.
2) parent child relationship table records we need to insert to target.we need to check the condition before insert,the condition is foreign key table record check the primary key table if record is available insert to target,otherwise we need give retry time period (5 times retry),for that time records is not in primary key table send error msg to mail.
how we do this please help me on this?
3) how to implment the load balance,that means we have 50000 records in source,but i need to insert the 1000 by 1000.
please help me on this?