Capturing Changes In Data

I'm looking at how SSIS would cope with populating DW with huge transactional tables capturing only changed data.
Can you use a table comparison transform, or is the approach to look at timestamp log files and 'Last Exection Date variables'.

Any comments appreciated

Yes, these are the general approaches.
You also have the option of transaction replication to a staging table, and then periodically running your ETL process.
K