You might want to look into the use of .RAW files in SSIS. They're basically SSIS's version of temp tables. What they do is pull off a single system into a file (local to the SSIS server is best) in a high-speed access version of the data (you won't be able to read it directly).
That raw can then be manipulated repeatedly. My personal use for it is usually when dealing with multiple warehouses, where I need to do heavy transforms and then port the results to multiple targets. First I'll do all the transforms into the raw, and then start pumping it out to the target systems. The reason for this is so I can checkpoint the transformation, keeping me from having to hit the source system more than once in case of a connection failure or somesuch.
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