March 7, 2012 at 6:14 pm
Hi All,
SCD Component Fails Saying that Target Table is Locked.
and return the Dead Lock Failure.
I am implementing the SCD 2, with the Start Date, End Date & Batch Number.
Please need help to get the Pointer why this Dead lock Occurs & Fail...!
Sudhir Nune.
March 8, 2012 at 12:18 am
You can start by doing research on what a deadlock is and how to prevent it.
Use profiler to find out which resources are blocking each other and try to resolve the issue.
Then, step away from the SCD component as it has horribly performance and code the SCD2 yourself 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 7:55 am
The SSIS built in SCD transormation is not very good. I actually had a developer on the SSIS team tell me to never use it. You would be better off building your own logic out of other components or downloading the Kimbal(?) SCD from Codeplex and trying that.
March 8, 2012 at 9:59 am
Daniel Bowlin (3/8/2012)
The SSIS built in SCD transormation is not very good. I actually had a developer on the SSIS team tell me to never use it. You would be better off building your own logic out of other components or downloading the Kimbal(?) SCD from Codeplex and trying that.
The name is changed to SSIS Dimension Merge because of legal issues with the Kimball Group.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2012 at 4:43 am
There is an another one called Cozy Rock's Table difference..it is good in performance wise. but need to add the update statement by our self...
Thanks,
Charmer
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply