July 3, 2008 at 8:44 am
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
July 3, 2008 at 11:47 am
In the data flow task, there are options to split data, add derived columns, etc. I think those are what you need.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 3, 2008 at 11:28 pm
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?
July 4, 2008 at 1:20 am
Can you explain bit more about it.
July 8, 2008 at 11:24 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply