david.ostrander (8/16/2012)
I would agree and would like to use the Multicast. I attached a image of what my Data Flow looks like at the moment.How can I upload my excel data to a temp table from with SSIS? Or do I even have to do that?
Regards,
D
Well, the structure looks right, but those OLEDB objects are complaining about something. You shouldn't need a temp table of any kind here, really. If you do need to do other things with the data afterwards, what you'll want is a staging table (a hard table dedicated to temporary storage for only this process) and not a #tmp, just so we're both speaking apples to apples.
If this is just a straight load though, no data manipulation and/or updating of previous information, you should be able to directly insert into both target tables, however. Can you give us more of a description of your end to end process?
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