To add to the recommendation to remove it, the SCD component in SSIS (at least in 05 and 08) is a piece of crap. The Inserts are fine. The Updates are Row by Row, as are Deletes, simply because the component has to be generic enough to handle all styles handled to it with the same code.
There are a number of tools in SSIS that are available so they exist, but they are not the best tool to use when you're working against a Database Engine. Sort, Aggregations, SCD, etc. are performance killers in SSIS. This is because they interrupt the flow/stream of data. They are typically there more for when you're using SSIS against non-native systems or simple datastores (DB2?), for example you need to sort a flat file to merge it to another flat file to output a third flatfile. Nowhere in there would you typically touch an engine.
Not all tools are created equal for all jobs.
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