November 28, 2007 at 7:15 am
Please help, Almost everyday I have two production jobs that abend with the following error, which I then have to rerun the jobs. The last steps in each package creates the index. The package completes successfully, But when you look at the LOG DETAIL that step to create the index is missing (not displayed) from the status.
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Could not drop constraint. See previous errors. (Microsoft OLE DB Provider for SQL Server (80040e14): 'PK_SAS_OPCHG07_set' is not a constraint.)
Step Error code: 80040E14
Step Error Help File:
Step Error Help Context ID:0
November 28, 2007 at 7:34 am
Looks to me that it's telling you that it can't drop the constraint because the constraint isn't there to drop. Try building the constraint by hand (to make sure it's there), and then re-run the process.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply