Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Savitha
Starting Member
2 Posts |
 Posted - 2013-11-11 : 05:43:26
|
| I'm working on table which is of SCD Type 2.The columns start_dt and end_dt has default values (9999-12-13).My scd type 2 logic is failing, as these 2 columns are not null.Though it inserts a new record, it does not update old_record end_dt to new record start_dt and old_record current_flg = N.The packageworks fine when tables end_dt and start_dt is NUll |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-11 : 06:27:10
|
| you need to update the tasks within package which SCD wizard inserts and change WHERE conitions to make start_dt is null and end_dt is null etc to start_dt = '99991213' etc as by default the code it puts is based on null------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSIS SCDType 2