Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Insert Failure Phase Not Firing - MultiPhase Data Pump

Insert Failure Phase Not Firing - MultiPhase Data Pump

Insert Failure Phase Not Firing - MultiPhase Data Pump

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.


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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close