I'm a bit short of time for a project so can't really do both and compare (but will at some point), so therefore;
What is quicker; an SQL statement or using the objects in SSIS?
i.e. If I can do a lookup by joined table or sub-query, is that quicker than the lookup object in SSIS?
Same goes for data conversions/cast statement, derived columns, the union object etc.
I'd assume they're slower which, if they are slower, then leads me to ask, are they only there for people that don't know SQL?