通过SSIS更新数据 [英] Update data through SSIS

问题描述

我们的情况是需要在桌面上更新数据。我们不允许用户直接在桌面上更新。我们已要求用户将数据复制到csv文件以获取他们需要完成的更改。 

We have a situation where data needs to be updated on a table. We are not allowing users to update directly on table. we have asked users to copy the data on to a csv file for the changes they need to done. 

每个表都有一个主键，我们需要实现其历史属性使用scd的数据。如果这是一种正确的方法或任何其他简单方法来解决这个问题，有人可以帮助我。

Each table has a primary key and we need to implement the historical attribute of the data by using scd. Can someone help me out if this is a right approach or any other easy way to handle this.

谢谢

推荐答案

嗨Rajm0019，

Hi Rajm0019,

SCD是。我假设变更跟踪也涉及历史，而不仅仅是前一次和最后一次更改。所以SCD Type 2就是这样。

SCD is. I assume the change tracking also involves history and not just the previous and last changes. So SCD Type 2 is the one to go.

你可以很容易地使用SSIS滚动
http://www.learnmsbitutorials.net/slowly-changing-dimensions-ssis.php

You can roll it using SSIS quite easily http://www.learnmsbitutorials.net/slowly-changing-dimensions-ssis.php

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