Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ssis insert to target before check parent child relationship Expand / Collapse
Posted Wednesday, June 12, 2013 11:25 PM


Group: General Forum Members
Last Login: Wednesday, October 9, 2013 1:15 AM
Points: 15, Visits: 167
Dear all,

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?

Post #1462904
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse