I have set up a small subset of records to manage Primary Key violation during a multiphase data pump. Every record in the subset will fail the primary key contraint.
The problem I am having is that the Insert Success phase is being called regardless of whether or not the insert is successful. On the other hand, the Insert failure is not being called as expected.
Only at the end of the Data pump does a violation message appear. I have done some research of when these phases are called and cannot explain the behaviour.
The Activex Script for the data pump is listed below.
Thanks.
The risk with keeping an open mind is having your brains fall out.
Shaunk
The problem I am having is that the Insert Success phase is being called regardless of whether or not the insert is successful. On the other hand, the Insert failure is not being called as expected.
Only at the end of the Data pump does a violation message appear. I have done some research of when these phases are called and cannot explain the behaviour.
The Activex Script for the data pump is listed below.
Thanks.
Code:
Function Main()
DTSDestination("org_unit_id") = DTSSource("org_unit_id")
DTSDestination("Start_Range") = DTSSource("Start_Range")
DTSDestination("End_Range") = DTSSource("End_Range")
DTSDestination("New_Referrals") = DTSSource("New_Referrals")
DTSDestination("New_Clients_Seen") = DTSSource("New_Clients_Seen")
Main = DTSTransformStat_OK
End Function
Function PreSourceMain()
PreSourceMain = DTSTransformstat_OK
End Function
Function InsertSuccessMain()
msgbox "Insert Success - made it"
InsertSuccessMain = DTSTransformstat_OK
End Function
Function InsertFailureMain()
msgbox "Insert Failure - made it"
InsertFailureMain = DTSTransformstat_OK
End Function
Function PumpCompleteMain()
PumpCompleteMain = DTSTransformstat_OK
End Function
The risk with keeping an open mind is having your brains fall out.
Shaunk