I currently have some standard SSIS packages in SQL Server that load and transform data from CSV files into a SQL Server database.
I would like to capture data lineage for these SSIS packages but am unsure how this can be done. Ideally i don't want to re-write the packages and was hoping if something could be 'switched on' as such. Is there anything built into SSIS/SQL Server or are there any 3rd party tools available?
Any advice would be greatly appreciated. Cheers
As data is processed by SSIS various adjustments can be made to the figures (rounding, multiplication, division etc....). These adjustments might be dynamic (based upon other data). I would like the ability to take a final value and look at history (data lineage) of this and see all the adjustments that have been made to get this value
You would have to program your package to actively store this data in whatever form you want to be able to retrieve it. There is nothing built into SSIS to do this automatically or even to make it especially easy to do.