Data Lineage in SQL Server

Transact-SQL
1

Hi,

I have a requirement to prepare the Data Lineage report which details how the data is moved from Staging to intermediate layer and then from intermediate to Target Database.
I have all the column level details for the tables in staging Database(around 20 tables) but the stored procedure logic for data movement from staging to intermediate to Target is quite complex.
Can someone please suggest the approach.

2

@rahul even if this question is pretty old, maybe it is still open to you. I recommend to check http://getmanta.com, it offers unique parsing capabilites and MS SQL is one of supported platforms. Tomas