Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert Failure Phase Not Firing - MultiPhase Data Pump

Status
Not open for further replies.

shaunk

Programmer
Aug 20, 2001
402
AU
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.

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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top