|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 25, 2009 7:08 AM
Points: 8,
Visits: 17
|
|
hello All
I have two databases having different relational structure. I need to get one table from source db to 2 destination tables which are connected with a foreign key constraints. for e.g. I have
source tabe
Person (PersonId, Name, city, country, zip code, phone, email)
I need to get that in
destination tables
Person(PersonId, Name),
ContactInfo(ContactInfoId, city, country, zip, phone, email) and
PersonContact(PersonId, ContactInfoId)
Please let me know any idea how i can do this in SSIS studio. also I need to import this data after each 4-5 hours.
Regards
Rashmi
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, July 01, 2009 12:21 PM
Points: 6,281,
Visits: 3,254
|
|
In the data flow task, there are options to split data, add derived columns, etc. I think those are what you need.
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 25, 2009 7:08 AM
Points: 8,
Visits: 17
|
|
Thanks for the reply.
is there any way to do the transactional update in database. I mean i need to insert contactinfo first and then based on the identities returned need to populate other tables.
any idea?
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 25, 2009 7:08 AM
Points: 8,
Visits: 17
|
|
| Can you explain bit more about it.
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, July 01, 2009 12:21 PM
Points: 6,281,
Visits: 3,254
|
|
Yes, you can do the "insert this table first to get the IDs" thing.
Insert into a table, select from it, join it to the data you inserted from. Voila! You have your IDs.
- GSquared
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
|
|
|
|
