Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Step Fails with EXCEPTION_ACCESS_VIOLATION

Author  Topic 

pagan1234
Starting Member

7 Posts

Posted - 2007-06-25 : 08:27:32
Hello,
I have searched Sql 2000 forum and couldn't find any thing related to the error i am getting. I have a job schedule in sql2000 SP4, which executes a DTS package. Job failed last night with this error message:

"Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:ConnectOLE Error--HRESULT: 0x80040005 Source: Microsoft SQL-DMO
Description: [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION
Step Error code: 80040E14
Step Error Help File:
Step Error Help Context ID:0"

I checked the DTS log and i found above error occurred at step 2, which is to execute a stored proc.

Any one has any idea about this error. Thanks for any help or suggestions.
   

- Advertisement -