Some ETL tools such as Informatica have data lineage built in. To my knowledge, SSIS does not. You'll have to either build on SSIS's auditing features or maybe find a third-party add on.