Extract ETL process of existing database

Asked Nov 26 '19 at 15:51

Active Nov 26 '19 at 15:51

Viewed 51 times

I have a pretty complex database, I have both its source code and access to it. My job is to answer the question ‘from what file, given column is loaded?’. Currently what I do is just go through code, from target column to source file. I wonder if there is any tool that would make it automatic or generate it based on SQL?

I'm using SQL Server.

asked Nov 26 '19 at 15:51

zimek-atomek

1

What tool are you use to load data? Some tools have such functionality, other don't. – Piotr Palka Nov 26 '19 at 15:53
Raw data is loaded into EXT tables using SSIS, then all operations and transformations are done within T-SQL queries. – zimek-atomek Nov 26 '19 at 16:16
Possible duplicate of [SQL Server SSIS Data Lineage](https://stackoverflow.com/questions/49946154/sql-server-ssis-data-lineage) – Piotr Palka Nov 26 '19 at 16:18

Extract ETL process of existing database

0 Answers0