dbTalk Databases Forums  

SQL Agent Job fails with Error: Invalid access to memory location.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL Agent Job fails with Error: Invalid access to memory location. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Holly
 
Posts: n/a

Default SQL Agent Job fails with Error: Invalid access to memory location. - 06-09-2006 , 06:10 PM






Just recently all of our scheduled SQL Agent jobs on a single SQL
server began failing with the following error:

Error: -2147023898 (800703E6); Provider Error: 0 (0) Error
string: Invalid access to memory location. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 713. Process Exit Code 1. The step
failed.

Running the jobs manually does not give us this error, they run just
fine.

Running the same jobs on other servers work, so it appears to be server
specific. Right about when the failures started we had a power outtage,
but the Networks groups say that this SQL server did not go down. It's
possible that a domain controller did though.

Does anyone have any experience troubleshooting this kind of error?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.