March 29, 2012 at 3:39 pm
I have an Excel spreadsheet with multiple records whose destination lives in one table and two reference tables. How do I map the flat file to three tables at once?
March 29, 2012 at 5:53 pm
is there a reason you need to? Just write 3 different queries, one for each table. Or have 3 dataflows in SSIS.
March 30, 2012 at 1:15 am
Can you give some sample input and desired output.
It's possible that you'll have to use a conditional split to route rows to 3 different destinations.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 30, 2012 at 8:42 am
Thanks, I was just thinking there may be a more automated way of doing this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply