Evil Kraig F (8/20/2012)
That shouldn't be too hard, actually, you merely only map the columns you need in the OLEDB destination to the table(s) in question. However, of a more critical issue, how do you determine which rows associate to each other between the tables, and does that key come from Excel? If it's a SQL generated surrogate key, this is going to require a lot more work.
Sounds like a multicast to two tables should do the job.
As for the association bit, I agree. To give better advice, we need to understand how the tables are linked. It may be wise to add a surrogate key to the spreadsheet and use that as an aid ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.