Re: DTS Error EXCEPTION_ACCESS_VIOLATION
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 04/27/04
- Next message: Darren Green: "Re: Order of Steps"
- Previous message: Darren Green: "Re: Changing the SqlTask Via ActiveX"
- In reply to: Sandeep: "DTS Error EXCEPTION_ACCESS_VIOLATION"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 22:11:09 +0100
In message <4f7901c42c88$cbd45080$a401280a@phx.gbl>, Sandeep
<anonymous@discussions.microsoft.com> writes
>Anybody ?? Please help
>Thanks
>
>Sandeep
>
>>-----Original Message-----
>>We have some DTS jobs that runs every night called via a
>>batch file. But since the past few days we are getting
>the
>>following error.
>>
>>Error: -2147221499 (80040005); Provider Error: 0 (0)
>> Error string: Need to run the object to perform this
>>operation
>> Error source: Microsoft Data Transformation Services
>>(DTS) Package
>> Help file: sqldts80.hlp
>> Help context: 4700
>>Error: -2147221499 (80040005); Provider Error: 0 (0)
>> Error string: Code execution exception:
>>EXCEPTION_ACCESS_VIOLATION
>> Error source: Microsoft Data Transformation Services
>>(DTS) Data Pump
>> Help file: sqldts80.hlp
>> Help context: 0
>>
>>I googled around and found suggestive measures like (run
>>on the same thread process, and explicit naming of server
>>instead of 'local') but that does not help either.
>>
>>We are running SQL Server 2000 SP3 on a windows 2000
>>Server machine.
>>
If you want fast support then you can pay for it through PSS and such
like. Newsgroups are free, and people answer when they feel like it with
no obligation to even do so.
Depending on the execution mechanism and task then there are some bugs,
e.g. -
316331 - FIX: DTSTransferObjects with Events Generates an Error Message
and an Access Violation in Visual Basic
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;316331)
By far the most common cause is still to do with threading. So any VB
custom task, or even some ActiveX Script Tasks that use VB COM objects
need to be set to execute on main thread.
Also any tasks like ActiveX Script task or Dynamic Properties Tasks that
touch in any way a VB task need to also run on the main thread. This
also includes the Exec Pkg Task that executes a child package which
contains a VB task.
So examine the tasks you have a check all suitable candidate tasks are
set to run on the main thread.
If this is no help, then please describe how you execute the package,
and what tasks it contains.
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Darren Green: "Re: Order of Steps"
- Previous message: Darren Green: "Re: Changing the SqlTask Via ActiveX"
- In reply to: Sandeep: "DTS Error EXCEPTION_ACCESS_VIOLATION"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
