CODEWITHSUNDEEP
ssisscd2
Voystin
Voystin

Reputation: 304

SCD2 in SSIS always see all records as new ones

Here is my issue: I want to build simply ETL process where in Data Flow I'm taking some data from my Staging schema and load them into other place. Also I need to implement SCD2 there. So in theory sounds simply - but SCD component in SSIS always see records as new so every time I'm executing my task it loads same data to my destination table even when there weren't any changes in source data.

In configuration of SCD component I assigned BusinessKey to column data which cannot be changed, I choose rest of dimension column as HistoricaAtributtes, set up start and end dates. Inferred member support is unchecked.

I'm using SSDT 2015 and DB engine is SQL Server 2016

Here is the screen with ETL:

ETL

Any advice on how to solve this issue?

Upvotes: 0

Views: 574

Answers (1)

Néstor Waldyd
Néstor Waldyd

Reputation: 1024

Use the SCD Advance Editor (Right Click+Show Advanced Editor...) and under the Component Properties Tab check for the Custom Properties. Specially take a look on CurrentRowWhere and SqlCommand SCD Component Properties. These will let you know why the records having identical Business Keys are determined as new.

Upvotes: 1

Related Questions