SQL Server SSIS 数据沿袭 [英] SQL Server SSIS Data Lineage

问题描述

我目前在 SQL Server 中有一些标准的 SSIS 包，可以将数据从 CSV 文件加载并转换到 SQL Server 数据库中.

I currently have some standard SSIS packages in SQL Server that load and transform data from CSV files into a SQL Server database.

我想捕获这些 SSIS 包的数据沿袭，但不确定如何做到这一点.理想情况下，我不想重新编写软件包，并且希望可以像这样打开"某些东西.SSIS/SQL Server 中是否内置了任何东西，或者是否有任何 3rd 方工具可用?

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

推荐答案

由于数据是由 SSIS 处理的，因此可以对数据进行各种调整数字(四舍五入，乘法，除法等......).这些调整可能是动态的(基于其他数据).我想要能够获取最终值并查看历史(数据沿袭)this 并查看为获得此值所做的所有调整

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

您必须对您的包进行编程，以便以您希望能够检索的任何形式主动存储这些数据.SSIS 中没有任何内置功能可以自动执行此操作，甚至无法使其特别容易执行.

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.

这篇关于SQL Server SSIS 数据沿袭的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！