Duplicate business key in existing dimension error?
Has anybody came across this error and no how to fix it? I have got a lot of integrity erros which seem to be coming from my Dimension Merge SCD and im wondering what is the problem.
I am new to ssis, my business key is the account_id if that helps.
many thanks
August 25th, 2011 12:23am
What type of dimension are you using?Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2011 2:14am
It's quite likely that you just have your SCD2 Date Handling in conflict with other things you're doing in the data flow. Can you post a screenshot of the data flow, along with a screenshot of the date handling tab from the DMSCD UI?
Talk to me now on
August 25th, 2011 10:59am