August 5, 2014 at 1:59 pm
Im keep getting the error message below and was told i that:
"The history pointers must have been corrupted during one of the failed imports. Basically you just need to find the last good pointer on each of the history files and then start the import manually from that point"
Its like greek to me. Can someone give me more detail on how to do that.
Here's the error message:
Executed as user: DATAWHSE\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:45:00 AM Error: 2014-08-05 03:45:27.11 Code: 0x00000000 Source: IST - History Files Update - CO1 Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user. at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread() End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:45:00 AM Finished: 3:45:27 AM Elapsed: 26.593 seconds. Process Exit Code 1. The step failed.
August 5, 2014 at 2:17 pm
erika 99577 (8/5/2014)
Im keep getting the error message below and was told i that:"The history pointers must have been corrupted during one of the failed imports. Basically you just need to find the last good pointer on each of the history files and then start the import manually from that point"
Its like greek to me. Can someone give me more detail on how to do that.
The only person who can give you more detail is the person who told you to do that. He's telling you to do something that is specific to your system and your DTS packages. There's no chance that any of us can help
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply