December 21, 2010 at 2:12 pm
i have two table X,Y with out any refrential Integrity,
i want them to be loaded into tables X1 and Y1 with Parent child relation
i mean the data from table X-->X1 and Y-->Y1 which also should satisfy the parent child relation b/w X1 and Y1
can you guys suggest me how to do that in SSIS
Thanks in Advance,
Sweatha
December 21, 2010 at 2:26 pm
Pretty easy, decide on the columns you will use to create the relationship. Set up your X1 & Y1 tables appropriately. Then use SSIS to pull the data from one set of tables to the other.
Will there be record or uniqueness issues when moving the data? That will probably add some difficulty.
December 21, 2010 at 3:22 pm
we do have that issue, if it does not satisfy the realtion ship we have to move them to the error tables,
so my idea is to write the separate queries for each of them
do you have any other idea ??
December 22, 2010 at 6:47 am
In SSIS (2008) I would probably just use a lookup ignoring errors, and then a conditional split to run all the logic of, is it a good record, is it a duplicate record, etc. and then route the split data streams to the appropriate destination tables.
December 22, 2010 at 11:28 pm
Yes It is possible first u create both table X1 and Y1 with referential integrity constraint like primary key and foreign key and then insert all record from both table with referencing with first to second table
January 21, 2011 at 11:11 pm
Having trouble to get the child package variable values.Any information will be helpful.
Again want to know ,can one variable be store or retrieve at a time in config file?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply