September 7, 2010 at 3:49 am
Hi All,
I have a package which uses SCD type 1 in SSIS.i truncated the table and loading it for the first time.Ideally,all the records should flow into New output of SCD instead it flows into Changing Attribute output also.this should happen only if i am running the package for the Second load.pkg has 4 business keys and are have duplicate business keys i.e there are records coming from source with duplicate business keys..is it possible in SCD Type 1 behave like that? please let me know.thanks for your help:)
September 7, 2010 at 4:45 am
Prasad,
Do you wish to keep the existing records..if yes then it is SCD Type 2
Raunak J
September 7, 2010 at 5:43 am
but i want to use SCD type 1 only..i increased Buffer size to maximum..it works until some rows say 1000 and then any increase is causing that update problem...my source has 18000 records...if any other work around is possible it would be of great help.
September 8, 2010 at 1:24 am
Are there any duplicates in your source?
Why don't you try to implement the SCD Type 1 yourself with an update and an insert statement. It will run a hell of a lot faster than the SCD component of SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 8, 2010 at 11:18 pm
Ya buddy...source table do have duplicates..I thought i'll implement this scenario with SCD itself but no luck.so i implemented it with LookUp transformation..well to remove duplicates,i used another Look Up x'form before the main Look Up with all the columns mapped except Timestamp column..it resolves that problem:)))
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply