david.ostrander (8/16/2012)
I currently have an SSIS package being built where I want to upload rows from an excel document into a Recordset Destination in SSIS. What I'm having trouble understanding is once the excel data is uploaded into the Recordset Destination how do I get that out and into two separate tables in my database with the data I want to query.
As Phil mentioned, a multi-cast is your best bet here. However, I'm not sure I understand your followup statement. Your OLEDB destination should be aimed at a table (or updateable view), not a SQL command. Then you map your inbound columns to where you want them to go, for both of them.
As to using the Recordset Destination, that's an in memory object you would need to use a for-each loop for in the control flow. It's best avoided unless you're looking to internally loop on a series of items internally in SSIS, which happens occassionally, but it does mean 1 by 1 inserts to the targets.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA