dbTalk Databases Forums  

DTS periodic failures

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


Discuss DTS periodic failures in the microsoft.public.sqlserver.dts forum.



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

Default DTS periodic failures - 05-11-2005 , 06:01 AM






Hi,

I have a server running on Windows Server 2003 and SQL Server 2000 SP3a.

It runs 16 DTS packages scheduled to run once per minute via SQL Server
Agent. Periodically TDSRun will fail with the following message in a dialog
box.

The exception Illegal Instruction
An attempt was made to access an illegal instruction
(0xc000001d) occurred in the application at location 0x007d24b4

The execution of the job is blocked at that point. This has happened on a
number of DTS packages. All the packages on the server have a connection to
the local SQL Server and an SQL Task. All the packages operate on a linked
server in the SQL Task. There are several databases involved on the linked
server but each DTS package only accesses a single database. The linked
server runs NT 4 SP6a and SQL Server 7 SP3.

Any ideas about what may be causing this problem or any steps I can take to
try to diagnose the cause?

Regards

James Wilman


Reply With Quote
  #2  
Old   
Michael Cheng [MSFT]
 
Posts: n/a

Default RE: DTS periodic failures - 05-11-2005 , 10:34 PM






Hi James,

Welcome to use MSDN Managed Newsgroup!

I have noticed you posted another thread titled: DTSRun periodic problem, I
am composing a reply to that thread and I will reply there if you have any
follow-up questions.

Please understand we are trying our best to help our subscribers resolve
problems in MSDN Managed Newsgroup, however our response time is expected
to be within 24 hours. While you need an urgent assistance, I recommend
that you open a Support incident with Microsoft Customer Service and
Support (CSS) so that a dedicated Support Professional can work with you in
a more timely and efficient manner. If you need any help in this regard,
please let me know.

For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.


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.