April 8, 2009 at 2:33 pm
I have 3 pieces of data coming from 3 different databases so as I understand it I need 3 different data flows as I am getting 3 different pieces of data.
For each data flow I'm using an OLEDB source which is connected to a derived column which connects to an OLEDB destination. The destination is the same for all 3 pieces of data.
The only problem is that this is creating 3 new rows and I only want one row with each piece of data in a different column.
Any help on this would be greatly appreciated.
April 8, 2009 at 2:37 pm
I think you can do that right in SSIS, but what I've done in the past is insert each into a separate "holding table", then use a query with the right joins to populate the final table. That may not be the best solution, but it's what I'm familiar with and it does work.
- 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
April 8, 2009 at 2:51 pm
OK. Thanks very much for the input.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply